DB1的aa表 字段 id ,name
DB2的bb表 字段idd,namee
字段类型一样
对表AA的操作后,BB表的数据也相应改变
1:更新
create TRIGGER TR_insert ON [dbo].[AA]
FOR update
AS
begin
update DB2.dbo.BB set namee=
(select name from inserted )
end
2:删除
create TRIGGER TR_delete ON [dbo].[AA]
FOR delete
AS
begin
delete DB2.dbo.BB where idd=
(select id from deleted)
end
3:插入
create TRIGGER TR_insert ON [dbo].[AA]
FOR INSERT
AS
begin
insert DB2.dbo.BB (namee)
select name from inserted
end