--跨服务器查询如下： SELECT a.*,b.stor_Name from OPENROWSET(MSDASQL, DRIVER={SQL Server};SERVER=tom;UID=sa;PWD=123, pubs.dbo.authors) AS a,stores b ORDER BY a.au_lname, a.au_fname --其中，tom为远程服务器名，stores... [阅读全文]