先開啟

exec sp_configure 'show advanced options',1
reconfigure
exec sp_configure 'Ad Hoc Distributed Queries',1
reconfigure

?

然后調(diào)用

INSERT INTO SoyErpBasicData.dbo.Base_Datadictionary ( Type ,
Code ,
Name ,
SeqNO ,
State ,
Notes ,
ParentID ,
IsLeaf_YN ,
CompCode
)
SELECT Type ,
Code ,
Name ,
SeqNO ,
State ,
Notes ,
ParentID ,
IsLeaf_YN ,
CompCode

FROM openrowset('SQLOLEDB','192.168.0.188';'sa';'hualong2012',SoyErpBasicData.dbo.Base_Datadictionary)

WHERE id IN (268,269)

?

調(diào)用完后關(guān)閉

exec sp_configure 'Ad Hoc Distributed Queries',0
reconfigure
exec sp_configure 'show advanced options',0
reconfigure

?

?

總結(jié)：很簡單的，三部曲

?

?

?

SQL數(shù)據(jù)庫，如何把服務(wù)器中的一張表插入到另外一個服務(wù)器的一張表中