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

日期:2010-05-28 15:28:34 人气:2

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

begin前要加上as: create trigger TR_DB01_AA_insert on AA for insert as begin insert into DB_02..AA select * from inserted insert into DB_03..AA select * from inserted end go create trigger TR_DB01_AA_update on AA for update as begin update a s
    A+
热门评论