[SQL SERVER] 跨服务器查询

select * from OPENDATASOURCE(

         ‘SQLOLEDB’,

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

         ).dbname.dbo.tablename

Leave a Comment

Your email address will not be published.

This site uses Akismet to reduce spam. Learn how your comment data is processed.