第一个触发器

create trigger tgr_zl_update
on zl_itm after update
as
begin
declare @LB varchar(50),@SJ varchar(50),@LS varchar(50),@ZH varchar(50)
select @LB = LB,@SJ = SJ,@LS = LS, @ZH = ZH from inserted
update b_itm set  LB = @LB,SJ=@SJ,LS = @LS where ZH = @ZH
end