若两个库在同一个服务器上,A在db1,B在db2则
insert into db2.B select col1,col2 from db1.A where .....
否则,可以建立linked server
然后
insert into server2.db2.B select col1,col2 from server1.db1.A where .....
insert into db2.B select col1,col2 from db1.A where .....
否则,可以建立linked server
然后
insert into server2.db2.B select col1,col2 from server1.db1.A where .....
--复制到一个新建的testdb数据库的TB_PUBS_AUTHORS表的相应列中
CREATE PROC prClonePubsAuthors
AS
INSERT testDB.dbo.TB_PUBS_AUTHORS(au_lname, au_fname)
SELECT au_lname, au_fname FROM pubs.dbo.authors
GO
如果在不同服务器上,可以用openrowset语句来实现。SELECT a.*
FROM OPENROWSET('SQLOLEDB','seattle1';'sa';'MyPass',
'SELECT * FROM pubs.dbo.authors ORDER BY au_lname, au_fname') AS a其中,seattle1为远程服务器名