求SQL 触发器代码:实现多个数据库下结构名称相同的多个表同步
求SQL 触发器代码:实现多个数据库下结构名称相同的多个表同步
日期:2010-05-28 15:28:34 人气:2
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