sql触发器怎么获取插入的记录转存到另一个数据库的表里？

Question

如题所述

Answer 1

CREATE TRIGGER a1_a ON [dbo].[a1]
FOR INSERT
AS
insert into b.dbo.b1(g,h,j)
select c as g,d as h,e as j from inserted

在A数据库A1表，加上面的触发器（只限于同一台服务器不通数据库数据转存），如果要在不同的服务器上，就先在A所在服务器上加链接服务器，触发器修改为：

CREATE TRIGGER a1_a ON [dbo].[a1]
FOR INSERT
AS
insert into [server name].b.dbo.b1(g,h,j)
select c as g,d as h,e as j from inserted

Answer 2

create trigger MytrName
on a1
for insert
insert into b数据库.b1
select c,d,e from inserted

请注意，两个数据库需要在一个服务器下