SELECT a.*
FROM OPENROWSET('SQLOLEDB','192.168.0.3';'sa';'',
'SELECT * FROM pubs.dbo.authors ORDER BY au_lname, au_fname') AS a
union all
SELECT b.*
FROM OPENROWSET('SQLOLEDB','192.168.0.2';'sa';'',
'SELECT * FROM pubs.dbo.authors ORDER BY au_lname, au_fname') AS b
GO
關鍵是OPENROWSET語句