--触发器的操作2
create trigger inserttableB
on tableA
after insert
insert into tableB select * from inserted
go
create trigger updatetableB
on tableA
after update
delete from tableB where id in (select id from deleted)
inert into tableB select * from inserted
go
create trigger deletetableB
on tableA
after delete
delete from tableB where id in (select id from deleted)
go
create trigger inserttableB
on tableA
after insert
insert into tableB select * from inserted
go
create trigger updatetableB
on tableA
after update
delete from tableB where id in (select id from deleted)
inert into tableB select * from inserted
go
create trigger deletetableB
on tableA
after delete
delete from tableB where id in (select id from deleted)
go
可以试试在作业开始时禁用触发器 alter table 表名 disable trigger all 作业最后后再开启触发器 alter table 表名 enable trigger all