[SQL SERVER] 跨服务器查询

select * from OPENDATASOURCE(

         ‘SQLOLEDB’,

         ‘Data Source=ServerName;User ID=MyUID;Password=MyPass’

         ).dbname.dbo.tablename