使用Opendatasource函数
select * from OPENDATASOURCE(
'SQLOLEDB',
'Data Source=192.168.1.239;User ID=sa;Password=123'
).hzyl_hgb.dbo.hzyl_bc_zyjl where fkey not in
(select INPATIENT_SN from D504)
and issc=1 and scrq>='2009-01-01'
exec sp_configure 'show advanced options',1
reconfigure
exec sp_configure 'Ad Hoc Distributed Queries',1
reconfigure
使用完毕后,记得要关闭它,因为这是一个安全隐患
exec sp_configure 'Ad Hoc Distributed Queries',0
reconfigure
exec sp_configure 'show advanced options',0
reconfigure