今天又学到了一点点!
存储远程机器的数据:
select * from opendatasource('sqloledb','data source=dataserver's name or ip;uer id=sa;password=sa').databasename.dbo.tablename
select * from opendatasource('sqloledb','data source=dataserver's name or ip;uer id=sa;password=sa').databasename.dbo.tablename