第一步: 使用sp_configure启用 'Ad Hoc Distributed Queries'(为了安全起见,使用完后,要关闭)
EXEC sp_configure 'show advanced options', 1
GO
RECONFIGURE
GO
EXEC sp_configure 'Ad Hoc Distributed Queries', 1
GO
RECONFIGURE
GO
第二步:查询sql语句
SELECT id,fdep_id
FROM OPENDATASOURCE(
'SQLOLEDB',
'Data Source=192.168.0.106;User ID=sa;Password=sa'
).bldb.bldb.larfield where id in
(select id from larfield20130617_1 where new_sort_id_len like '%8%')
第三步:关闭'Ad Hoc Distributed Queries'
EXEC sp_configure 'show advanced options', 0
GO
RECONFIGURE
GO
EXEC sp_configure 'Ad Hoc Distributed Queries', 0
GO
RECONFIGURE
GO