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
Ïà¹ØÎĵµ£º
½ñÌìÐÇÆÚÌì,ÒòÊý¾Ý¿âÌ«Âý,×îºó¾ö¶¨½«Êý¾Ý¿â½øÐÐÖØÐÂÕûÀí.
(¼Ù¶¨Êý¾Ý¿âÃû³ÆΪ£ºDB_ste)
1¡¢¸ù¾ÝÏÖÔÚµÄÊý¾Ý¿âµÄ½Å±¾´´½¨Ò»¸ö½Å±¾Îļþ£¨FILENAME£ºDB_ste.sql)
2¡¢½¨Á¢ÐµÄÊý¾Ý¿âDB_ste2,ÈôÓÐÎļþ×éµÄÊý¾Ý¿â,ÔòÐèÒª½¨Á¢ÏàͬµÄÎļþ×é¡££¨DB_ste_Group)
3¡¢½«Êý¾ÝÎÄ ......
Microsoft SQL Server ±í²»Ó¦¸Ã°üº¬Öظ´ÐкͷÇΨһÖ÷¼ü¡£Îª¼ò½àÆð¼û£¬ÔÚ±¾ÎÄÖÐÎÒÃÇÓÐʱ³ÆÖ÷¼üΪ“¼ü”»ò“PK”£¬µ«ÕâʼÖÕ±íʾ“Ö÷¼ü”¡£Öظ´µÄ PK Î¥·´ÁËʵÌåÍêÕûÐÔ£¬ÔÚ¹ØϵϵͳÖÐÊDz»ÔÊÐíµÄ¡£SQL Server Óи÷ÖÖÇ¿ÖÆÖ´ÐÐʵÌåÍêÕûÐԵĻúÖÆ£¬°üÀ¨Ë÷Òý¡¢Î¨Ò»Ô¼Êø¡¢Ö÷¼üÔ¼Êøº ......
<?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'; ......
×÷Õß Haidong Ji ·Òë GoodKid
ÔÚÎҵĹØÓÚOracleºÍSQL Server »¥ÓÃÐÔµÄϵÁÐÎÄÕ part 1 ºÍ part 2 µ±ÖУ¬ÎÒÌÖÂÛÁËOracleºÍSQL Server µÄһЩ²»Í¬µãµÄ»°ÌâÒÔ¼°OracleÇý¶¯µÄ¿ÉÑ¡ÐÔ¡£ÔÚ±¾Ö÷ÌâÖУ¬ÎÒ½«ÌÖÂÛÒ»¸öÀ´×ÔOracle 10gµÄй¤¾ß£¬Oracle¼´Ê±¿Í»§¶Ë¡£
¶ÔÓÚOracle 10gÒÔÇ°µÄ°æ±¾£¬Èç¹ûÏ뽨Á¢ºÍOracleµÄÁ¬½Ó£¬ ......
8.2 ¾ÛºÏº¯ÊýµÄÓ¦ÓÃ
¾ÛºÏº¯ÊýÔÚÊý¾Ý¿âÊý¾ÝµÄ²éѯ·ÖÎöÖУ¬Ó¦ÓÃÊ®·Ö¹ã·º¡£±¾½Ú½«·Ö±ð¶Ô¸÷¾ÛºÏº¯ÊýµÄÓ¦ÓýøÐÐ˵Ã÷¡£
8.2.1 ÇóºÍº¯Êý——SUM()
ÇóºÍº¯ÊýSUM( )ÓÃÓÚ¶ÔÊý¾ÝÇóºÍ£¬·µ»ØÑ¡È¡½á¹û¼¯ÖÐËùÓÐÖµµÄ×ܺ͡£Óï·¨ÈçÏ¡£
SELECT SUM(column_name) ......