求SQL 触发器代码:实现多个数据库下结构名称相同的多个表同步

日期:2010-06-02 11:26:37 人气:1

求SQL 触发器代码:实现多个数据库下结构名称相同的多个表同步

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
    A+
热门评论