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

SQL Server ÒÆÖ²µ½Oralce ÏîĿʵս

ÏîÄ¿±³¾°
         ÒÆÖ²Ò»¸öÏÖÓÐϵͳµ½Oracle¡£Ô­ÏµÍ³»ùÓÚ.Net Framework 1.1, SQL Server 2000Êý¾Ý¿â£¬Êý¾Ý²Ù×÷»ù±¾È«²¿Ê¹ÓÃStore Procedure£¬×ÜÊýÓâǧ£¬Òò´Ë×ÜÌåÉæ¼°µÄPL SQL ¿ª·¢Á¿±È½Ï´ó¡£
 
         ÓÅÏȼ¶¸ß£¬¿ª·¢Ê±³Ì¶Ì£¬²ÎÓëÈËÔ±¶à£¬ÊÇÕâ¸öÏîÄ¿µÄÏÔÖøÌص㡣±¾ÈË×÷ΪÏîÄ¿¸ºÔðÈË£¬Ö÷Òª°´ÕÕÏÂÁв½Öè½øÐУ¬×îÖÕÔ²Âú´ï³ÉÄ¿±ê¡£
 
µÚÒ»²½    ÆÀ¹À
1.       È·ÈÏÐèÒªÒÆÖ²µÄ¹¦ÄÜÁбí
2.       ÆÀ¹ÀÖ÷Òª¹¤×÷Á¿
¹¤×÷ÖصãÔÚÓÚÒÆÖ²SQL Server SPµ½ Oracle Package£¬Ô¤¹ÀÒÆÖ²Ò»¸öSPËùÐèƽ¾ùʱ¼äµÈ
 
µÚ¶þ²½    Ç°ÆÚ×¼±¸
1.       È·¶¨Ä¿±êOracleÊý¾Ý¿âµÄ°æ±¾(Oracle10.1.0.5.0)ºÍ±àÂë(ACTUTF8)
Êý¾Ý¿âµÄ±àÂëÈ·¶¨·Ç³£ÖØÒª£¬ÓÉÓÚԭϵͳ֧³Ö¶àÓïÑÔ´æ´¢£¬ËùÒÔOracleÎÒÃÇÑ¡ÔñÁËACTUTF8¡£ÕâÖÖ±àÂë¶ÔÓ¦µÄSQL Server ÖУ¬1¸ö×Ö·ûÕ¼3¸ö×Ö½Ú¡£
2.       Oracle Êý¾Ý¿âÉè¼Æ(×ÉѯOracle DBA)
3.       ÆÀ¹À¼¼ÊõÄѵ㣬ÕÒ½â¾ö·½°¸
1)       IdentityÀ¸Î»ÊµÏÖ
ʹÓÃTrigger
2)       ÁÙʱ±íʵÏÖ
ʹÓÃOracleµÄÁÙʱ±í(8iºóÒÑÌṩ)
3)       .Net OracleÇý¶¯³ÌÐò
²ÉÓÃODP.NET
4.       È·¶¨SQL Server -> Oracle ±í / À¸Î»Ó³Éä¹Øϵ£¬ÐγÉSQL Server/Oracle ±í¶ÔÕÕÎĵµ
1)       Ò»°ãÔ­Ôò£¬Ô­¶ÔÏóµÄÃû³Æ²»×ö¸Ä±ä£»
2)       À¸Î»ÀàÐÍ£¬×Ö·ûÀàÐÍ -> VARCHAR2,  Êý×ÖÀàÐÍ -> NUMBER(m, n)£»
3)       À¸Î»³¤¶È£¬×î´ó³¤¶È *3£¬ ±£´æ¹Ì¶¨³¤¶ÈIDµÄÀ¸Î»³¤¶È²»×ö±ä¸ü£»
4)       ÔÚOracle Öн¨Á¢¶ÔÓ¦±í£¬Í¨¹ýSQL Server DTSµ¼Èë»ù´¡Êý¾Ý
5.       SPʹÓÃPackage×éÖ¯£¬²¢ÖØÐÂÃüÃû£¬ÐγÉSQL Server/Oracle SP¶ÔÕÕÎĵµ¡£
ÒòΪOracle ¶ÔÏóÃû³Æ³¤¶È²»Äܳ¬¹ý30£¬SQL Server µÄSP³¤¶ÈÆձ鳬¹ý30£¬Òò´ËÐèÒªÖØÐÂÃüÃû²¢·Ö×é¡£
6.     &nb


Ïà¹ØÎĵµ£º

SQL SERVERSÊý¾ÝÕûÀí

          ½ñÌìÐÇÆÚÌì,ÒòÊý¾Ý¿âÌ«Âý,×îºó¾ö¶¨½«Êý¾Ý¿â½øÐÐÖØÐÂÕûÀí.
(¼Ù¶¨Êý¾Ý¿âÃû³ÆΪ£ºDB_ste)
1¡¢¸ù¾ÝÏÖÔÚµÄÊý¾Ý¿âµÄ½Å±¾´´½¨Ò»¸ö½Å±¾Îļþ£¨FILENAME£ºDB_ste.sql)
2¡¢½¨Á¢ÐµÄÊý¾Ý¿âDB_ste2,ÈôÓÐÎļþ×éµÄÊý¾Ý¿â,ÔòÐèÒª½¨Á¢ÏàͬµÄÎļþ×é¡££¨DB_ste_Group)
3¡¢½«Êý¾ÝÎÄ ......

ÈçºÎɾ³ý SQL Server ±íÖеÄÖظ´ÐÐ

    Microsoft SQL Server ±í²»Ó¦¸Ã°üº¬Öظ´ÐкͷÇΨһÖ÷¼ü¡£Îª¼ò½àÆð¼û£¬ÔÚ±¾ÎÄÖÐÎÒÃÇÓÐʱ³ÆÖ÷¼üΪ“¼ü”»ò“PK”£¬µ«ÕâʼÖÕ±íʾ“Ö÷¼ü”¡£Öظ´µÄ PK Î¥·´ÁËʵÌåÍêÕûÐÔ£¬ÔÚ¹ØϵϵͳÖÐÊDz»ÔÊÐíµÄ¡£SQL Server Óи÷ÖÖÇ¿ÖÆÖ´ÐÐʵÌåÍêÕûÐԵĻúÖÆ£¬°üÀ¨Ë÷Òý¡¢Î¨Ò»Ô¼Êø¡¢Ö÷¼üÔ¼Êøº ......

½ÓÉÏһƪÎÄÕ£¬µ¼³öÒ»¸ö±í£¬»òÕßÕû¸öÊý¾Ý¿âµ½SQLÐÎʽ

 <?php
 require_once '../../smartyConfig/smartyConfig.class.php';
 require_once '../../game/include/function.php';
 require_once '../../game/include/config.php';
 require_once '../../game/server/server.class.php';
 require_once '../../game/include/db.class.php'; ......

OracleÓëSQL ServerÊý¾Ý»¥ÓÃÐÔ£¨3£©

 ×÷Õß Haidong Ji  ·­Òë GoodKid
ÔÚÎҵĹØÓÚOracleºÍSQL Server »¥ÓÃÐÔµÄϵÁÐÎÄÕ part 1 ºÍ part 2 µ±ÖУ¬ÎÒÌÖÂÛÁËOracleºÍSQL Server µÄһЩ²»Í¬µãµÄ»°ÌâÒÔ¼°OracleÇý¶¯µÄ¿ÉÑ¡ÐÔ¡£ÔÚ±¾Ö÷ÌâÖУ¬ÎÒ½«ÌÖÂÛÒ»¸öÀ´×ÔOracle 10gµÄй¤¾ß£¬Oracle¼´Ê±¿Í»§¶Ë¡£
¶ÔÓÚOracle 10gÒÔÇ°µÄ°æ±¾£¬Èç¹ûÏ뽨Á¢ºÍOracleµÄÁ¬½Ó£¬ ......

sql ³£ÓþۺϺ¯Êý

8.2  ¾ÛºÏº¯ÊýµÄÓ¦ÓÃ
¾ÛºÏº¯ÊýÔÚÊý¾Ý¿âÊý¾ÝµÄ²éѯ·ÖÎöÖУ¬Ó¦ÓÃÊ®·Ö¹ã·º¡£±¾½Ú½«·Ö±ð¶Ô¸÷¾ÛºÏº¯ÊýµÄÓ¦ÓýøÐÐ˵Ã÷¡£
8.2.1  ÇóºÍº¯Êý——SUM()
ÇóºÍº¯ÊýSUM( )ÓÃÓÚ¶ÔÊý¾ÝÇóºÍ£¬·µ»ØÑ¡È¡½á¹û¼¯ÖÐËùÓÐÖµµÄ×ܺ͡£Óï·¨ÈçÏ¡£
SELECT          SUM(column_name) ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ