Question

请教同一个服务器，两个数据库之间同步更新数据的触发器SQL语句

我要更新两个数据库中，同一个数据库表的触发器语句要如何写。
数据库（uf_001_2009和uf_002_2009），两个数据库中都有一个表（ComputationGroup）表的结构相同。我想要uf_001_2009数据库表ComputationGroup中增加删除修改数据的时候，同时更新uf_002_2009中的ComputationGroup表。请问谁能帮我写一个语句。同时把语句做一下必要的注释，我没有写过触发器。

Answer 1

一个例子：
create table t_a(id int identity(1,1),username varchar(20))

create table t_b(id int identity(1,1),username varchar(20))

create trigger tr_a on t_a
for update,insert,delete
as
alter table t_b DISABLE TRIGGER tr_b
----------------------------------
if not exists (select * from deleted) --插入
insert t_b(username) select username from inserted
else if not exists (select * from inserted)--删除
delete t_b where id in (select id from deleted)
else--更新
update a set a.username=i.username from t_b as a,inserted as i where a.id=i.id
alter table t_b ENABLE TRIGGER tr_b

------------------------------------------
create trigger tr_b on t_b
for update,insert,delete
as
alter table t_a DISABLE TRIGGER tr_a
----------------------------------
if not exists (select * from deleted) --插入
insert t_a(username) select username from inserted
else if not exists (select * from inserted) --删除
delete t_a where id in (select id from deleted)
else --更新
update a set a.username=i.username from t_a as a,inserted as i where a.id=i.id
alter table t_a ENABLE TRIGGER tr_a

select * from t_a
select * from t_b

--测试：
insert t_a(username) values('test')
insert t_b(username) values('test2')
update t_a set username='test1' where id=1
update t_b set username='test3' where id=1
delete from t_a where id=1
delete from t_b where id=2
--------------------------
select * from t_a
select * from t_b

Answer 2

CREATE TRIGGER 触发器名称 ON [dbo].[表名]
FOR INSERT, UPDATE, DELETE
AS
begin
insert 数据库.dbo.表名(列名) select scend from inserted
end