求SQL 触发器代码:实现多个数据库下结构名称相同的多个表同步
求SQL 触发器代码:实现多个数据库下结构名称相同的多个表同步
日期:2010-06-02 11:26:37 人气:1
create trigger TR_AA_insert
on AA
for insert,update,delete
as
begin
Delete from DB_02..AA where id in(Select id from deleted)
insert into DB_02..AA select * from inserted
Delete from DB_03..AA where id in(Select id from deleted)
insert into DB