用触发器解决,很方便,如下: 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
insert into B select A form A where argge =1
定义一个job定时执行下面的语句:insert into B(one,two,three) select one,two,three from A where A.agree=1
select * from A where agree=1
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
select one,two,three from A where A.agree=1