SQL查询不同服务器数据方法

---使用前，开启Ad Hoc Distributed Queries：

exec sp_configure'show advanced options',1 

reconfigure 

exec sp_configure'Ad Hoc Distributed Queries',1 

reconfigure 

 

 

----使用完成后，关闭Ad Hoc Distributed Queries：

 

exec sp_configure'Ad Hoc Distributed Queries',0 

reconfigure 

exec sp_configure'show advanced options',0 

reconfigure

 

 

 

Select * fromOPENDATASOURCE ('SQLOLEDB','Data Source=.;User ID=sa;Password=123').DataBase.dbo.Table

WHERE BusDicID NOTIN(Select BusDicID from OPENDATASOURCE ('SQLOLEDB','DataSource=192.168.1.20;User ID=sa;Password=123').DataBase.dbo.Table)