远程查询

/*
--开启远程访问
exec sp_configure 'show advanced options',1
reconfigure
exec sp_configure 'Ad Hoc Distributed Queries',1
reconfigure*/


select * from openrowset('SQLOLEDB','IP';'用户名';'密码',库名.dbo.表名)


/*
--关闭远程访问
exec sp_configure 'Ad Hoc Distributed Queries',0
reconfigure
exec sp_configure 'show advanced options',0
reconfigure */