select * from OPENROWSET
('SQLOLEDB','SERVER=ip or servername ;uid=loginname;pwd=pwd;Database=database,'select * from dbo.yourtable')
例如:要查询出192.168.1.2 上的数据库pibs 表authors中查询 登录名:sa 密码为空
select * from OPENROWSET
('SQLOLEDB','SERVER=192.168.1.2;uid=sa;Database=pubs,'select * from dbo.authors)