1,178
社区成员
发帖
与我相关
我的任务
分享
--同步插入和更新
create trigger tr_sync_add on table1
for insert,update as
set nocount on
if exists(select 1 from table2 where stuid2 in (select stuid1 from inserted))
update table2 set card2=y.card1,name2=y.name1 from table2 x,inserted y where x.stuid2=y.stuid1
else
insert into table2 select * from inserted
go
--同步删除
create trigger tr_sync_del on table1
for delete as
set nocount on
delete table2 where stuid2 in (select stuid1 from deleted)