如何用触发器实现数据同步？ 在线等～～

[gooood]

在database中有2个表，A、B，结构一样

现在如何实现在A表上创建触发器实现B表和A表的数据同步？

谢了

[pengdali]

CREATE TRIGGER 名1 ON dbo.tabMain
FOR INSERT
AS
insert tabSlave select * from inserted
go

CREATE TRIGGER 名2 ON dbo.tabMain
FOR update
AS
update tabSlave set 列=aa.列 from inserted aa where aa.编号=tabSlave.编号
go

CREATE TRIGGER 名3 ON dbo.tabMain
FOR delete
AS
delete tabSlave where 编号 in (select 编号 from deleted)

[txlicenhe]

create trigger tname1 on A
for insert,update,delete
as
....
　同步修改B表



create trigger tname1 on B
for insert,update,delete
as
....
同步修改A表

[zjcxc]

要求表有主键(这里假设为id),而且主键不能是标识字段


--创建同步的触发器
create trigger t_test on 表A
for insert,update,delete
as
delete from 表B where id in(select id from deleted)
insert into 表B select * from inserted
go