Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

SQL Server [·Ö²¼Ê½²éѯ/ÊÂÎñ]

·Ö²¼Ê½²éѯ
    OPENROWSET
    ´ÓExcelÈ¡Êý¾Ý
    SELECT * from OPENROWSET('Microsoft.Jet.OLEDB.4.0','Excel 8.0;Database=d:\1.xls',[Sheet1$])
    ´ÓOracleÈ¡Êý¾Ý
    SELECT * from OPENROWSET('MSDAORA.1','NetServiceName';'User';'Password','SELECT * from OracleTalbe')
 
    Linked Server(for Oracle)
    ½¨Á¢Linked Server
    sp_addlinkedserver'Allies', 'Oracle', 'MSDAORA.1', 'NetServiceName'
    OracleµÄLogin
    sp_addlinkedsrvlogin'Allies', FALSE, 'SQLServerLogin', 'OracleUser', 'OraclePassword'
    ´ÓOracle²éѯÊý¾Ý
    SELECT*from OPENQUERY( Allies, 'SELECT * from OracleTalbe')£¬»òÕß
    SELECT*from Allies..OracleUser.OracleTalbe
    ÐÞ¸ÄLinked ServerµÄServer Option
     sp_serveroption'Allies', 'Option Name', 'Option Value'
    ÀýÈç
    sp_serveroption'OraDC', 'rpc out', 'true'
    sp_serveroption'OraDC', 'rpc', 'true'
    ÏòOracle²åÈëÊý¾Ý£¨»¹Ã»ÓÐÓùý£©
    INSERT INTO OPENQUERY(Allies, 'SELECT ... from OracleTalbe WHERE 1=2') VALUES ( ... )
    ɾ³ýLinked Server
    sp_dropserver'Allies', 'droplogins'
 
    ×¢Ò⣺ʹÓÃOPENROWSET¡¢OPENQUERYʱ£¬SQL Server²»¶ÔÌá½»µÄSQLÓï¾ä×öÈκμì²é£¬Ö±½Ó½«Óï¾äÌá½»¸øLinked Server½øÐд¦Àí£»Ê¹ÓÃËIJ¿·ÖÃüÃû·¨Ê±£¬SQL Server¿ÉÄÜ´ÓLinked ServerÉ϶ÁÈ¡±»ÒýÓñíµÄÊý¾Ýµ½SQL Server£¬È»ºóÔÚSQL ServerÉÏÀ´Íê³ÉÆäËü²Ù×÷¡£
 
    ÉèÖÃSQL Serverµ½OracleµÄLinked Server£¬¿É²Î¿¼ÒÔÏÂKBÎÄÕ£º
    How to set up and troubleshoot a linked server to Oracle in SQL Server
    Limitations of Microsoft Oracle ODBC Driver and OLEDB Provider
    Techniques to Debug Connectivity Issues to an Oracle Server Using the ODBC Driver


Ïà¹ØÎĵµ£º

vb.net SQLÊý¾Ý¿â²Ù×÷£¨¶ÁÈ¡¡¢Ð޸ġ¢É¾³ý£©

        Dim rs As ADODB.Recordset
Dim sqlstr As String
 
'²éѯ
        sqlstr = "select * from ±íÃû where ×Ö¶ÎÃû = '" & ²éѯµÄÄÚÈÝ & "'"
        rs = VScn.Execute("" & SqlSt ......

SQLÓï¾äµÄMINUS,INTERSECTºÍUNION ALL

SQLÓï¾äÖеÄÈý¸ö¹Ø¼ü×Ö:MINUS(¼õÈ¥),INTERSECT(½»¼¯)ºÍUNION ALL(²¢¼¯);
¹ØÓÚ¼¯ºÏµÄ¸ÅÄî,ÖÐѧ¶¼Ó¦¸Ãѧ¹ý,¾Í²»¶à˵ÁË.ÕâÈý¸ö¹Ø¼ü×ÖÖ÷ÒªÊǶÔÊý¾Ý¿âµÄ²éѯ½á¹û½øÐвÙ×÷,ÕýÈçÆäÖÐÎĺ¬ÒåÒ»Ñù:Á½¸ö²éѯ,MINUSÊÇ´ÓµÚÒ»¸ö²éѯ½á¹û¼õÈ¥µÚ¶þ¸ö²éѯ½á¹û,Èç¹ûÓÐÏཻ²¿·Ö¾Í¼õÈ¥Ïཻ²¿·Ö;·ñÔòºÍµÚÒ»¸ö²éѯ½á¹ûûÓÐÇø±ð. INTERSECTÊÇÁ½¸ö² ......

sql server 2005 µ¼³öÓû§±íÊý¾Ý×Öµä(×ªÔØ)

-----------------------------------------------------
--×÷ÓãºÓÃÓÚsql server 2005 µ¼³öÓû§±íÊý¾Ý×Öµä
--1 ĬÈϵ¼³öµ±Ç°Êý¾Ý¿âÖÐËùÓÐÓû§±í(xtype = 'u')µÄÊý¾Ý×ֵ䣻
--2 ¿ÉÒÔÔÚxtype = 'u'Ìæ»»ÎªÈçÏÂËùʾÓï¾äxtype = 'u' and name in ('son','Person') µ¼³ö×Ô¶¨ÒåµÄ±íµÄÊý¾Ý×ֵ䣻
--3 ¿ÉÒÔÀûÓü¯³É·þÎñSSISµ¼³ ......

MS SQL ServerÁ¬½ÓOracle

1.  °²×°oracle 10G¿Í»§¶Ë
Òª·ÃÎÊoracleÊý¾Ý¿â±ØÐë°²×°oracle¿Í»§¶Ë¡£°²×°oracle¿Í»§¶ËÓÐÁ½ÖÖ·½Ê½£¬¼´ÍêÕû°²×°ºÍÁ¢¼´°²×°£¬ÕâÁ½ÖÖ·½Ê½¶¼¿ÉÒÔ¡£°²×°ÍêºóÅäÖÃÒªÁ´½ÓÊý¾Ý¿â·þÎñÆ÷¡£
$ORACLE_HOME\network\admin\tnsname.ora
ÔÚ´ËÅäÖÃÎļþÀïÌí¼ÓÈçÏÂÄÚÈÝ£º
sunora =
  (DESCRIPTION =
    ......

SQL Server 2005 ´´½¨µ½ Oracle10g µÄÁ´½Ó·þÎñÆ÷

SQL Server 2005 ´´½¨µ½ Oracle10g µÄÁ´½Ó·þÎñÆ÷
ÓÉ lwgboy @ MoFun.CC, ÔÚ 08-9-12 ÏÂÎç5:00
±ê¼Ç: linkserver, oracle, sqlserver, Á´½Ó·þÎñÆ÷
SQL Server 2005 ´´½¨µ½ Oracle10g µÄÁ´½Ó·þÎñÆ÷
SQL Server 2005 ÒìÀàÊý¾ÝÔ´(ORACLE10G)Á´½Ó·þÎñÆ÷µÄ½¨Á¢
±¾ÎļòÊöSqlServer 2005 Á´½Óµ½ Oracle10g ·þÎñÆ÷µÄ¹ý³Ì¼°»ù ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ