create trigger tname1 on b表
for insert
as
insert a select * from inserted
gocreate trigger tname2 on b表
for update
as
update a set a.F1 = b.F1,a.f2 = b.f2 ...
from inserted b where b.主键 = a.主键
gocreate trigger tname3 on b表
for delete
as
delete a from deleted b where b.主键 = a.主键
go
for insert
as
insert a select * from inserted
gocreate trigger tname2 on b表
for update
as
update a set a.F1 = b.F1,a.f2 = b.f2 ...
from inserted b where b.主键 = a.主键
gocreate trigger tname3 on b表
for delete
as
delete a from deleted b where b.主键 = a.主键
go
for insert
as
insert a select * from inserted
go
如果B表插入3条记录A表会有重复记录为什么
FOR INSERT, UPDATE, DELETE
AS
delete b
where b.id in(select id from deleted)
insert b
select * from inserted
这样你可以少写一个删除触发器