create trigger t
on ygxq
for update
as
if update(ygh)
begin
update ygkq set ygh=i.ygh from ygkq a,inserted i inner join deleted d on a.ygh=d.ygh
update gjb set ygh=i.ygh from gjb a,inserted i inner join deleted d on a.ygh=d.ygh
end
CREATE TRIGGER Tygh ON ygxq
FOR UPDATE
AS
declare @ygh varchar(50),
@ygh_old varchar(50)
select @ygh=ins.ygh from inserted ins
select @ygh_old=del.ygh from deleted del
update ygkq set ygh = @ygh where ygh = @ygh_old
update gjb set ygh = @ygh where ygh = @ygh_old