SQL ServerÁ¬½ÓÔ¶³ÌÊý¾ÝÔ´µÄ»ù±¾·½·¨

SQL ServerÁ¬½ÓÔ¶³ÌÊý¾ÝÔ´µÄ»ù±¾·½·¨ÓÐÏÂÃæÈýÖÖ£º
OPENDATASOURCE: The OPENDATASOURCE function is used to specify connection information for a remote data source by specifying the OLE DB provider and an initialization string. OPENDATASOURCE can be used directly within a SELECT, INSERT, UPDATE, or DELETE statement.
OPENROWSET: The OPENROWSET function is used to specify connection information for a remote data source and the name of an object that will return a result set (such as a stored procedure) or a query that will return a result set. Like OPENDATASOURCE, OPENROWSET can be used directly within a SELECT, INSERT, UPDATE, or DELETE statement.
Linked servers: A linked server is an object within SQL Server that defines the connection properties of another SQL Server. When defined, queries can connect to the remote server using a four-part name, such as
SQLSrv1.AdventureWorks.person.Contact
The four-part name identifies the server (SQLSrv1), the database (AdventureWorks), the schema (Person), and the object (Contact table). Linked servers are explored in more depth in the final section of this chapter.
ÆäÖÐOPENDATASOURCEºÍOPENROWSET·½·¨Ò»°ãÓÃÀ´×öÁÙʱ²éѯ£¨ad hoc query£©£¬Èç¹ûÐèÒª¾­³£µÄ²éѯԶ³ÌÊý¾Ý£¬Ôò½¨Òé´´½¨linked servers¡£µ«ÊÇ£¬Ä¬ÈÏÇé¿öad hoc query ÊǽûÓõģ¬ÐèÒªÊÖ¶¯Æô¶¯£º
sp_configure ‘show advanced options’, 1;
GO
RECONFIGURE;
GO
sp_configure ‘Ad hoc Distributed Queries’, 1;
GO
RECONFIGURE;
===========================
³£ÓÃÓï¾ä£º
SELECT a.*
from OPENROWSET('Microsoft.Jet.OLEDB.4.0',
   'd:\aaa.xls';'admin';'', data)
   AS a
 ÒÔÏÂÓï¾äÄܳɹ¦,ÉÏÒ»ÌìÓï¾äÈ´²»ÐÐ:OLE DB Ìṩ³ÌÐò 'Microsoft.Jet.OLEDB.4.0' ±¨´í¡£
[OLE/DB provider returned message: ²»¿Éʶ±ðµÄÊý¾Ý¿â¸ñʽ 'd:\aaa.xls'¡£]
SELECT *
from OpenDataSource( 'Microsoft.Jet.OLEDB.4.0',
 'Data Source="d:\aaa.xls";User ID=Admin;Password=;Extended properties=Excel 5.0')...data$
SELECT *
from OpenDataSource( 'Microsoft.Jet.OLEDB.4.0',  'D