CREATE TRIGGER [TRI_del] ON [a]
FOR insert
AS
insert into bdb.dbo.b (a1,a2,a3)
select a1,a2,a3 from inserted
delete a from a a,inserted b where a.a1=b.a1 and a.a2=b.a2 and a.a3=b.a3
FOR insert
AS
insert into bdb.dbo.b (a1,a2,a3)
select a1,a2,a3 from inserted
delete a from a a,inserted b where a.a1=b.a1 and a.a2=b.a2 and a.a3=b.a3
instead of insert --注意触发器类型
as
insert B表 select * from inserted
在插入到了其它的数据库里了!
create trigger tr_insert on A表
instead of insert --注意触发器类型
as
insert DBB.dbo.B表 select * from inserted