insert into tablename
SELECT * FROM        
OPENDATASOURCE('SQLOLEDB', 'Data Source=192.168.18.252;User ID=sa;Password=test').pubs.dbo.authors

------解决方案--------------------
探讨

SQL codeinsert into tablename
SELECT * FROM        
OPENDATASOURCE('SQLOLEDB', 'Data Source=192.168.18.252;User ID=sa;Password=test').pubs.dbo.authors


------解决方案--------------------
用dts，不要写一行代码，简单方便，好用。

------解决方案--------------------
楼上的方法都可以 但是要有跨库访问权限   sa 之类级别的才行

------解决方案--------------------
insert tb_1(a,b,c) select a1,b1,c1 from tb_2 in datasource.dbo.table where 条件

------解决方案--------------------
3楼的即可.

------解决方案--------------------
收藏。。。。

------解决方案--------------------
探讨

SQL codeinsert into tablename
SELECT * FROM        
OPENDATASOURCE('SQLOLEDB', 'Data Source=192.168.18.252;User ID=sa;Password=test').pubs.dbo.authors


------解决方案--------------------
探讨

SQL codeinsert into tablename
SELECT * FROM        
OPENDATASOURCE('SQLOLEDB', 'Data Source=192.168.18.252;User ID=sa;Password=test').pubs.dbo.authors