sqlserver如何使用数据链路查询

方法一、
exec sp_addlinkedserver 'srv_lnk','','SQLOLEDB','10.0.2.2'

exec sp_addlinkedsrvlogin 'srv_lnk','false',null,'zhk','zhk'
go
select * from srv_lnk.zhk.dbo.send_backup
exec sp_dropserver 'srv_lnk','droplogins'

方法二、

select * from openrowset('sqloledb','10.0.2.2';'zhk';'zhk',zhk.dbo.send_backup)