34,587
社区成员
发帖
与我相关
我的任务
分享
create trigger tri on t1
for update
as
update a set t2.A=i.A
from t2 a,inserted i,deleted d
where a.A=d.A
go
create triger tr_up_t1
for update as begin
update t2 set a=inserted.a
from t2, inserted
where t2.id=inserted.id