有条件的实现两表之间数据同步

[xiaojiezizizi]

例如 A表.有字段
one two three agree

B表.
one two three four



当A表agree字段为1时. 才同步数据到B表


请问要怎么实现呢?

谢谢

[快溜]

insert into B
 select * from A where agree=1

[-晴天]

可以用触发器,当插入数据时,判断agree的值,如为1,则同时插入到B表.

[xiaojiezizizi]

[Quote=引用 2 楼 qianjin036a 的回复:]

可以用触发器,当插入数据时,判断agree的值,如为1,则同时插入到B表.
[/Quote]

可以给个例子么?

[richardi]

用触发器解决，很方便，如下：
create table A(one int,two int,three int ,agree int)
GO
create table B(one int,two int,three int ,four int)
GO

--写个触发器
create trigger tr_test on A
for insert
as
insert B(one,two,three) select one,two,three from inserted where agree=1

GO

--测试
insert A(one,two,three,agree)values(1,1,1,1)
insert A(one,two,three,agree)values(2,2,2,2)
insert A(one,two,three,agree)values(3,3,3,1)


select * from a
select * from b

[新丁11111]

如楼上所说，用触发器解决就可以的

[richardi]

给分吧。

[勿勿]

insert into B  select A form A where argge =1

[cutebear2008]

定义一个job定时执行下面的语句：

insert into B(one,two,three) 
select one,two,three from A where A.agree=1