ʹÓÃSQL ServerµÄOPENROWSETº¯Êý
¡¡Äã¿ÉÄܳ£³£»áÐèÒªÔËÐÐÒ»¸öad hoc²éѯ´ÓÔ¶³ÌOLE DBÊý¾ÝÔ´ÌáÈ¡Êý¾Ý£¬»òÕßÅúÁ¿ÏòSQL Server±íµ¼ÈëÊý¾Ý¡£ÔÚÕâÖÖÇé¿öÏ£¬Äã¿ÉÒÔÔÚT-SQL(Transact-SQL£¬Î¢Èí¶ÔSQLµÄÀ©Õ¹)ÖÐÓÃOPENROWSETº¯Êý¸øÊý¾ÝÔ´´«ÈëÒ»¸öÁ¬½Ó´®ºÍ²éѯÀ´ÌáÈ¡ÐèÒªµÄÊý¾Ý¡£
¡¡¡¡Äã¿ÉÄܳ£³£»áÐèÒªÔËÐÐÒ»¸öad hoc²éѯ´ÓÔ¶³ÌOLE DBÊý¾ÝÔ´ÌáÈ¡Êý¾Ý£¬»òÕßÅúÁ¿ÏòSQL Server±íµ¼ÈëÊý¾Ý¡£ÔÚÕâÖÖÇé¿öÏ£¬Äã¿ÉÒÔÔÚT-SQL(Transact-SQL£¬Î¢Èí¶ÔSQLµÄÀ©Õ¹)ÖÐÓÃOPENROWSETº¯Êý¸øÊý¾ÝÔ´´«ÈëÒ»¸öÁ¬½Ó´®ºÍ²éѯÀ´ÌáÈ¡ÐèÒªµÄÊý¾Ý¡£
¡¡¡¡Äã¿ÉÒÔʹÓÃOPENROWSETº¯Êý´ÓÈκÎÖ§³Ö×¢²áOLE DBµÄÊý¾ÝÔ´»ñÈ¡Êý¾Ý£¬±ÈÈç´ÓSQL Server»òAccessµÄÔ¶³ÌʵÀýÖÐÌáÈ¡Êý¾Ý¡£Èç¹ûÄãÓÃOPENROWSET´ÓSQL ServerʵÀýÖлñÈ¡Êý¾Ý£¬¸ÃʵÀý±ØÐëÅäÖÃΪÔÊÐíad hoc·Ö²¼Ê½²éѯ¡£
¡¡¡¡ÒªÅäÖÃÔ¶³ÌSQL ServerʵÀýÖ§³Öad hoc²éѯ£¬ÐèҪʹÓÃϵͳ´æ´¢¹ý³Ìsp_configureÏÈÉèÖÃadvanced options£¬ÔÙÆôÓÃAd Hoc Distributed Queries(ad hoc·Ö²¼Ê½²éѯ)¡£Çë¿´ÏÂÃæµÄT-SQL½Å±¾£º
¡¡¡¡EXEC sp_configure 'show advanced options', 1;
¡¡¡¡GO
¡¡¡¡RECONFIGURE;
¡¡¡¡GO
¡¡¡¡EXEC sp_configure 'Ad Hoc Distributed Queries', 1
¡¡¡¡GO
¡¡¡¡RECONFIGURE;
¡¡¡¡GO
¡¡¡¡Òª×¢ÒâµÄÊÇ£¬ÔÚÔËÐÐÍê´æ´¢¹ý³ÌÖ®ºó£¬Äã±ØÐëÔËÐГRECONFIGURE”ÃüÁî¡£ Ò»µ©ÄãÅäÖúÃÁËÔ¶³ÌSQL ServerʵÀý£¬Äã¾Í¿ÉÒÔ¶ÔËüʹÓÃOPENROWSETº¯Êý¡£Õâ¸öº¯Êý¿ÉÒÔÔÚSELECTÓï¾äµÄfrom´Ó¾äÀïʹÓá£ÏÂÃæµÄÀý×ÓÏÔʾÁ˸ú¯ÊýµÄ»ù±¾Óï·¨£º
¡¡¡¡OPENROWSET('provider', 'connection string', target)
¡¡¡¡¿ÉÒÔ¿´µ½£¬Õâ¸öº¯ÊýÓÐÈý¸ö²ÎÊý£º
¡¡¡¡·Provider —— Ä³ÌØ¶¨Êý¾ÝÔ´Ö§³ÖµÄOLE DBÌṩÕßµÄÈË»úÓѺÃÃû³Æ(ProgID)¡£ProviderµÄÃû×Ö±ØÐëÓõ¥ÒýºÅÀ¨ÆðÀ´¡£
¡¡¡¡·Connection string —— Á¬½Ó´®¡£ËüÊÇÓë¾ßÌåÌṩÕßproviderÏà¹ØµÄ×Ö·û´®£¬°üÀ¨Á¬½Óµ½¸ø×Ö·û´®ÖÐÖ¸¶¨µÄÊý¾ÝÔ´ËùÐèÒªµÄϸ½ÚÐÅÏ¢¡£¸ù¾ÝproviderµÄ²»Í¬£¬Á¬½Ó´®ÐÅÏ¢ÐèÒªÓÃÒ»¶Ô»ò¶à¶Ôµ¥ÒýºÅÀ¨ÆðÀ´¡£
¡¡¡¡·Target —— target²ÎÊý¿ÉÒÔʹһ¸öÊý¾Ý¿â¶ÔÏó»òÕßÒ»¸ö²éѯ¡£
¡¡¡¡·Object —— Êý¾Ý¿â¶ÔÏóµÄÃû×Ö£¬±ÈÈç±í»òÕßÊÓͼµÄÃû³Æ¡£¶ÔÏóµÄÍêÕûÃû×Ö±ØÐëÌṩ£¬ËüÃDz»ÐèÒªÓõ¥ÒýºÅÀ¨ÆðÀ´¡£
¡¡¡¡·Query —— queryÊÇ´ÓÔ¶³ÌÊý¾ÝÔ´ÌáÈ¡Êý¾ÝµÄSelectÓï¾ä¡£Query±ØÐëÓõ¥ÒýºÅÀ¨ÆðÀ´¡£
¡¡¡¡ÏÂÃæµÄÀý×ÓչʾÁËOPENROWSETº¯ÊýµÄÓ÷¨£º
¡¡
Ïà¹ØÎĵµ£º
declare @tmp table
(
id int identity(1,1),
TableName varchar(100),
Column_name varchar(100),
Type varchar(50),
Lenght int,
Scale int,
Nullable varchar(1),
Defaults varchar(4000),
PrimaryKey varchar(1)
)
select iid = identity(int,1,1), * into #a from SysObjects where xtype = 'U'
declare ......
ÎÒÔÚʹÓÃPL/SQLʱ£¬µã»÷ij¸ö×Ö¶ÎÅԱߵÄС°´Å¥Ï£Íûµ¯³ö±à¼´°¿Úʱ£¬PL/SQLÌáʾ“ÎÞЧµÄ´°¿Ú¾ä±ú”¡£Ò»Ö±²»Ã÷°×ÊÇÔõô»ØÊ£¬ºóÀ´baiduÁËÏ£¬²ÅÖªµÀÕâ¸ö¹¦ÄܺÍwindowsµÄprint spooler·þÎñÓйء£Æô¶¯¸Ã·þÎñ¾Í¿ÉÒÔÁË¡£ ......
·½·¨1£º
Ò»¡¢ÕÒÒ»ÕÅSQL server·þÎñÆ÷°æ¹âÅÌ£¬ÔÚ¹âÅÌÉÏÕÒµ½Ä¿Â¼“MSDE”²¢½øÈ룬ÔËÐÐSETUP.EXEÎļþ£¬²¢°´ÕÕ³ÌÐòÒªÇó½øÐа²×°¡£°²×°Íê³ÉÖØÐÂÆô¶¯¼ÆËã»ú¡£
¶þ¡¢ÔËÐйâÅÌÖеģ¬AUTORUN.EXEÎļþ£¬»òÈùâÅÌ×Ô¶¯ÔËÐУ¬´ò¿ª°²×°½çÃæºó£¬
µã»÷“°²×°SQL server 2000×é¼þ£¨C£©”-->“°²×°Êý¾Ý¿â·þÎñÆ ......
Ò»¡¢¹ØÓÚ»ù´¡±í
Oc_COJ^c680758
rd-A6z\&[1R1] H680758
Oracle
10G֮ǰ£¬ÆôÓÃAUTOTRACE¹¦ÄÜÐèÒªÊÖ¹¤´´½¨plan_table±í£¬´´½¨½Å±¾Îª$ORACLE_HOME/rdbms/admin
/utlxplan.sql¡£µ«ÔÚ10gÖУ¬ÒѾĬÈÏ´´½¨ÁËPLAN_TABLE$µÄ»ù±í£¬²¢ÒÔpublicÓû§´´½¨ÁËÏàÓ¦µÄͬÒå´ÊPUBLIC¡£ITPUB¸öÈ˿ռäDR#IlHrT
ITPUB¸ ......
SQL Native Client ODBC Driver
±ê×¼°²È«Á¬½Ó
Driver={SQL Native Client};Server=myServerAddress;Database=myDataBase;Uid=myUsername;Pwd=myPassword;
ÄúÊÇ·ñÔÚʹÓÃSQL Server 2005 Express ÇëÔÚ“Server”Ñ¡ÏîʹÓÃÁ¬½Ó±í´ïʽ“Ö÷»úÃû³Æ\SQLEXPRESS”¡£
ÊÜÐŵÄÁ¬½Ó
Driver={SQL Native ......