CREATE TRIGGER 名1 ON dbo.tabMain FOR INSERT AS insert db2..tabSlave select * from insertedCREATE TRIGGER 名2 ON dbo.tabMain FOR update AS update db2..tabSlave set 列=aa.列 from inserted aa where aa.编号=db2..tabSlave.编号 CREATE TRIGGER 名3 ON dbo.tabMain FOR delete AS delete db2..tabSlave where 编号 in (select 编号 from deleted)
大力写的就比较详细了 我刚刚那个写错了,应该是: insert into DB_2..table select * from inserted 不好意思:)
FOR INSERT
AS
insert db2..tabSlave select * from insertedCREATE TRIGGER 名2 ON dbo.tabMain
FOR update
AS
update db2..tabSlave set 列=aa.列 from inserted aa where aa.编号=db2..tabSlave.编号
CREATE TRIGGER 名3 ON dbo.tabMain
FOR delete
AS
delete db2..tabSlave where 编号 in (select 编号 from deleted)
我刚刚那个写错了,应该是:
insert into DB_2..table
select * from inserted
不好意思:)