Start SQL Server Remote Server Operate

--start OpenRowSet and OpenDatasource          

exec sp_configure'show advanced options',1

reconfigure

exec sp_configure'Ad Hoc Distributed Queries',1

reconfigure

--Exec add, delete, query, update

select * from openrowset('SQLOLEDB','serverName';'userid';'password',test.dbo.stu)

Select s.stuid From OPENDATASOURCE('SQLOLEDB','Data Source=v-liuke;User ID=sa; Password=password').test.dbo.stus s

转载于:https://www.cnblogs.com/qqliukk/p/3368728.html