insert db2.dbo.table2(id,title,content) select * from db1.dbo.table1
insert into table2 select id,title,content from table1
insert db2.dbo.table2(id,title,content) select id,title,content from db1.dbo.table1
最好在db1.dbo.table1的表中加个字段,以标志某行是否已经被插入到db2.dbo.table2中 这样的话语句变为如下: insert db2.dbo.table2(id,title,content) select id,title,content from db1.dbo.table1 where db1.dbo.table1.标志字段=‘未插入’ update db1.dbo.table1 set db1.dbo.table1.标志字段=‘已插入’
--更新标志字段时也可以在table2中建立一个触发器来实现 --如下: use test if object_id('tr_insert') is not null drop trigger tr_insert go create trigger tr_insert on t1 for insert as begin declare @name varchar(10) select @name=name from inserted update 学习.dbo.t1 set Flag=1 endinsert into test.dbo.t1 select Name from 学习.dbo.t1select * from test.dbo.t1 select * from 学习.dbo.t1
use Table2 goInsert Into Table2(id,title,content) select id,title,content from DB1..TABLE1
上面错了一点点use DB2 goInsert Into Table2(id,title,content) select id,title,content from DB1..TABLE1
INSERT INTO DB2..TABLE2(id,title,content) SELECT id,title,content FROM DB1..TABLE1
select id,title,content from db1.dbo.table1
这样的话语句变为如下:
insert db2.dbo.table2(id,title,content)
select id,title,content from db1.dbo.table1 where db1.dbo.table1.标志字段=‘未插入’
update db1.dbo.table1 set db1.dbo.table1.标志字段=‘已插入’
--如下:
use test
if object_id('tr_insert') is not null
drop trigger tr_insert
go
create trigger tr_insert
on t1
for insert
as
begin
declare @name varchar(10)
select @name=name from inserted
update 学习.dbo.t1 set Flag=1
endinsert into test.dbo.t1 select Name from 学习.dbo.t1select * from test.dbo.t1
select * from 学习.dbo.t1
goInsert Into Table2(id,title,content) select id,title,content from DB1..TABLE1
goInsert Into Table2(id,title,content) select id,title,content from DB1..TABLE1
http://topic.csdn.net/u/20080227/14/8bce0844-bd15-42f0-9cda-a343d5d6601b.html