SQL连接远程数据库

exec sp_configure 'show advanced options',1

go

reconfigure

go

exec sp_configure 'Ad Hoc Distributed Queries',1

go

reconfigure

go

select * from  

  OpenRowset('MSDASQL'  

  ,'DSN=FIX Dynamics Real Time Data'  

  ,'Select A_TAG,A_DESC from SCADA1')