服务器端
insert into Tab1(Id1,Name1,Value1)
select Id2,Name2,Value2
from OPENDATASOURCE('MSDASQL','DRIVER={SQL Server};SERVER=IP或主机名;UID=sa;PWD=密码;').库名.dbo.Tab2
本地
insert into Tab1(Id1,Name1,Value1) select Id2,Name2,Value2 from Tab2
转载于:https://www.cnblogs.com/EasyData/archive/2007/06/20/789867.html