资料同步,该怎么解决

资料同步
将A数据库的 表1 在更新资料的时候，同步在B数据库的表1.；两个表字段是一模一样的，大家帮忙给点资料。谢谢！

[解决办法]

SQL code

--在A库和B库上都建一个如下的tb表if object_id('tb') is not null   drop table tbgocreate table tb( id int, name varchar(10))go--在A库的tb上建插入触发器if object_id('tr_tb_forinsert') is not null   drop trigger tr_tb_forinsertgocreate trigger tr_tb_forinsert on tbfor insertas  insert into B.dbo.tb select * from insertedgo--在A库的tb上建更新触发器if object_id('tr_tb_forupdate') is not null   drop trigger tr_tb_forupdategocreate trigger tr_tb_forupdate on tbfor updateas   update B.dbo.tb set id=t2.id,name=t2.name from B.dbo.tb t1 inner join inserted t2 on t1.id=t2.idgo--在A库执行插入和更新语句，触发器会自动执行B库tb表的插入和更新insert into tb select 1,'张三'update tb set name='李四' where id=1
[解决办法]
SQL code
create trigger [dbo].[TableA_Trigger] on  [dbo].[TableA] for insert,update,delete as begin declare @operatetype char(1); Begin IF EXISTS(SELECT 1 FROM inserted) AND NOT EXISTS(SELECT 1 FROM deleted) set @operatetype ='1'; else IF NOT EXISTS(SELECT 1 FROM inserted) AND EXISTS(SELECT 1 FROM deleted) set @operatetype ='2'; else  set @operatetype ='3'; end  if(@operatetype ='2') begin INSERT INTO [TableA_LOG] ([a],[b],[Operatetype],[OperateTime]) select [a],[b],@operatetype,getdate() from deleted end else begin INSERT INTO [TableA_LOG] ([a],[b],[Operatetype],[OperateTime])  select [a],[b],@operatetype,getdate()from inserted end endGO