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
原文：http://www.cnblogs.com/dabexiong/p/5213719.html