SQL 两张表同步数据

在SQL中如何实现不同数据库的两张表的同步
你可以分三个来写,分别用来监视insert\delete\update三个(这样写容易完成),我下面写一个,你其它有可以参照下面这个来写
--插入行的情况
CREATE TRIGGER [填入触发器名] ON [dbo].[表名]
FOR INSERT
AS
insert [另外一个数据库名].[dbo].[表名] select * from inserted
你也可以参照料我下面这段,写在一起,但比较麻烦,我就不具体按你要求的写了罗. CREATE trigger [数据库A.tr_user] on [user]
/* 触发器在数据库A的user表建立一个名字tr_user的触发器*/
for update,insert,delete
/*监视修改插入删除*/
as
if not exists (select * from deleted)
/* 如果deleted表为空,那么*/
insert 数据库 B..[user](username,userpass,landtime) select username,password,lastlogin from inserted
/* 将inserted表(就是对于触发器来说刚刚被插入的集合)插入到er */
else if not exists (select * from inserted)--删除
/* 否则如果inserted集合为空*/
delete 数据库B..[user] where id in (select userid from deleted)
/* 那么删除er下id是deleted集合中出现的id 这里用了in */
else--更新
update [user]
set
[user].username=ername,
[user].userpass=i.password
from 数据库B..[user] as [user],
inserted as i
where [user].id=erid
/* update就很明显了,凡是updated的都来更新,保持一样就可以了*/
alter table 数据库B..[user] ENABLE TRIGGER [数据库B.tr_user]
在SQL中如何实现不同数据库的两张表的同步直接可以用了，不过这里我假设主键是id
CREATE TRIGGER tr1
ON DB_01.dbo.PA
FOR INSERT
AS
BEGIN
insert into DB_02.dbo.PA select * from Inserted i END
CREATE TRIGGER tr2
ON DB_01.dbo.PA
FOR delete
AS
BEGIN
delete DB_02.dbo.PA
from DB_02.dbo.PA,deleted
where DB_02.dbo.PA.id=deleted.id
END
CREATE TRIGGER tr3
ON DB_01.dbo.PA
FOR update
AS
BEGIN
delete DB_02.dbo.PA
from DB_02.dbo.PA,deleted
where DB_02.dbo.PA.id=deleted.id
insert into DB_02.dbo.PA select i.* from inserted i END
CREATE TRIGGER tr4
ON DB_02.dbo.PA
FOR INSERT
AS
BEGIN
insert into DB_01.dbo.PA select * from Inserted i
END
CREATE TRIGGER tr5
ON DB_02.dbo.PA
FOR delete
AS
BEGIN
delete DB_01.dbo.PA
from DB_01.dbo.PA,deleted
where DB_01.dbo.PA.id=deleted.id
END
CREATE TRIGGER tr6
ON DB_02.dbo.PA
FOR update
AS
BEGIN
delete DB_01.dbo.PA
from DB_01.dbo.PA,deleted
where DB_01.dbo.PA.id=deleted.id
insert into DB_01.dbo.PA select i.* from inserted i END。