跨库操作!

SELECT *
FROM OPENROWSET('Microsoft.Jet.OLEDB.4.0',
   'd:/northwind.mdb';'admin';'',
   Customers)

-- SELECT from a table on another instance of SQL Server.
SELECT *
FROM OPENDATASOURCE(
          'SQLOLEDB',
          'Data Source=MLServer;User ID=sa;Password=s1a2'
                   ).food2.dbo.UserDetail
SELECT *
FROM OpenRowset('Microsoft.Jet.OLEDB.4.0',
   'd:/northwind.mdb';'admin'; '',
   'SELECT CustomerID, CompanyName,Region
         FROM Customers
         WHERE Region = ''WA'' ')