openrowset

启用：
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


SELECT     *
FROM         OPENROWSET('SQLOLEDB.1', 'Provider=SQLOLEDB.1;server=;database=;uid=;pwd=;',
                      'SELECT * FROM TBL_LMS_CARGO')
或者
 SELECT    *
   FROM       OPENROWSET('SQLOLEDB', 'server'; uid'; 'pwd', sql')