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

SQL 92 ±ê×¼ YoYo

        ÏîÄ¿ÖÕÓÚ½áÊøÁË£¬×ܽáµÄʱºòµ½ÁË... hehe :)
        ÔÚÏîÄ¿ÖÐÎÒÃÇÓöµ½Á˺ܶàµÄÎÊÌ⣬±ê×¼SQLʹÓþÍÊÇÆäÖÐÒ»¸ö¡£ ÒòΪÎÒÃÇÔÚ×öBI packageµÄʱºò£¬Ò»¿ªÊ¼¶¼ÊÇ»ùÓÚMS SQL À´×öµÄ£¬ËùÒÔUniverseµÄÉè¼ÆÉÏҲûÓÐÌ«¶àµÄ¿¼ÂÇ¡£ µ±ºóÀ´ÀÏ´ó¸æËßÎÒżÃÇҪͬʱrelease Ò»¸ö»ùÓÚ Oracle µÄ°æ±¾Ê±£¬ÎÒÃDzŷ¢ÏÖÎÊÌâÀ´ÁË¡£ ÒòΪÔÚUniverseÀïÃæÎÒÃÇʹÓõÄSQLºÜ¶à¶¼²»ÊDZê×¼µÄSQL£¬ºÜ¶à¶¼ÊÇMSSQLËù¶ÀÓеģ¬Ò²¾ÍÊÇ T-SQL(Transcate SQL)£¬ ËùÒÔµ±°ÑuniverseÒÆÖ²µ½OracleÉϵÄʱºò£¬ÎÒÃDz»µÃ²»ÎªOracleÖØÐÂ×öÁËÒ»Ì×Universe¡£ÓÖÒòΪDashboardºÍCrystal Reports¶¼ÊÇ»ùÓÚUniverseÀ´×öµÄ£¬ËùÒÔ×îºóÎÒÃǵÄefforts ±»À©´óÁËÒ»±¶ ... ±­¾ß°¡£¡£¡
        ÏîÄ¿×öÍêÁË£¬ÏÖÔÚÀ´Ñо¿ÏÂÄÄЩSQLÊÇͨÓõ쬷ÀÖ¹ÒÔºó²»Òª·¸Í¬ÑùµÄ´íÎó¡£  ÒÔÏÂÄÚÈݾùΪ±¾ÈËgoogle ËùµÃ£¬×ªÔØà¶~~   hehe~
¡¾¸ÅÄî×ܽ᡿
1. »ù±¾Ó¦ÓÃÉÏ£¬sql server ºÍoracle¶¼×ñÑ­sql 92Óï·¨±ê×¼¡£
2. Êµ¼ÊÓ¦ÓÃÖдó¼Ò¶¼»á³¬³öÒÔÉϱê×¼£¬Ê¹Óø÷¼ÒÊý¾Ý¿â³§É̶¼ÌṩµÄ·á¸»µÄ×Ô¶¨Òå±ê×¼º¯Êý¿âºÍÓï·¨¡£
3. Î¢Èísql serverµÄsql À©Õ¹½ÐT-SQL(Transcate SQL).
4. Oracle µÄsql À©Õ¹½ÐPL-SQL.
5. ×î¼òµ¥µÄ²åÈ롢ɾ³ý²Ù×÷¶¼²î²»¶à£¬µ«ÊÇÉÔ΢¸´ÔÓÒ»µã£¬¶¼²»Ò»ÑùÁË¡£±ÈÈçÉæ¼°µ½¿çÊý¾Ý±í£¬¿çÊý¾Ý¿â£¬¿çÓû§µÄ²Ù×÷µÄÓï·¨²»Ò»Ñù¡£
6. Ò»¸öºÜ¼òµ¥µÄÀý×Ó£¬È¥Êý¾Ý¿âϵͳʱ¼äµÄд·¨
tsql: select getdate()
pl-sql: select sysdate from dual
¡¾SQL 92¹ú¼Ê±ê×¼¡¿
1. HOWTO - SQL92 Syntax
    - http://owen.sj.ca.us/rkowen/howto/sql92F.html
2. Wikipedia
    - http://en.wikipedia.org/wiki/SQL-92
    - http://en.wikipedia.org/wiki/SQL
¡¾Ç°ÈË×ܽ᡿
1. OracleÓëSQL ServerµÄ¼¸µã²»Í¬
    - http://www.programfan.com/blog/article.asp?id=9101
2. SQL 92Óï·¨±ê×¼
ÒÔÏÂÄÚÈÝÀ´×ÔCSDN²©¿Í£¬×ªÔØÇë±êÃ÷³ö´¦£ºhttp://blog.csdn.net/wnhoo/archive/2007/04/11/1560941.aspx
==================================================
SQL92 Syntax and common or <Oracle> additions (not = '!')


Ïà¹ØÎĵµ£º

sql 2005 ´æ´¢¹ý³Ì·ÖÒ³ java ´úÂë

 create PROCEDURE pagelist
@tablename nvarchar(50),
@fieldname nvarchar(50)='*',         
@pagesize int output,--ÿҳÏÔʾ¼Ç¼ÌõÊý
@currentpage int output,--µÚ¼¸Ò³
@orderid nvarchar(50),--Ö÷¼üÅÅÐò
@sort int,--ÅÅÐò·½Ê½£¬1±íʾÉýÐò£¬0±íʾ½µÐòÅÅÁÐ ......

Win7ϰ²×°SQL Server2005

ÔÚWin7ϰ²×°SQL2005¿ª·¢°æ£¬°²×°SQL Native ClientʱÌáʾ°²×°Öжϣ¬Ã»ÓÐÔÚÒ⣬ȻºóÔÚ°²×°SQL ServerʱÓÖÌáʾ“[Microsoft][SQL Native Client]¿Í»§¶Ë²»Ö§³Ö¼ÓÃÜ.SQL Server °²×°³ÌÐòÎÞ·¨Á¬½Óµ½Êý¾Ý¿â·þÎñ½øÐзþÎñÆ÷ÅäÖÃ.”Ð¶ÔØSQL Native ClientÖØÐ°²×°£¬»¹ÊÇÖжϣ¬ÐÞ¸´£¬Ò²Öжϣ¬ÔÙÐ¶ÔØ£¬ÇåÀí×¢²á±í£¬ÖØ× ......

SQLÈÕÆÚ¸ñʽ»¯Ó¦ÓôóÈ«

Sql Server ÖÐÒ»¸ö·Ç³£Ç¿´óµÄÈÕÆÚ¸ñʽ»¯º¯Êý
:
Select CONVERT(varchar(100), GETDATE(), 0): 05 16 2006 10:57AM
Select CONVERT(varchar(100), GETDATE(), 1): 05/16/06
Select CONVERT(varchar(100), GETDATE(), 2): 06.05.16
Select CONVERT(varchar(100), GETDATE(), 3): 16/05/06
Select CONVERT(varchar(100), ......

ͨ¹ý·ÖÎöSQLÓï¾äµÄÖ´Ðмƻ®ÓÅ»¯SQL(Èý)

ËÄ£ºORACLEµÄÓÅ»¯Æ÷
ÓÅ»¯Æ÷ÓÐʱҲ±»³ÆÎª²éѯÓÅ»¯Æ÷£¬ÕâÊÇÒòΪ²éѯÊÇÓ°ÏìÊý¾Ý¿âÐÔÄÜ×îÖ÷ÒªµÄ²¿·Ö£¬²»ÒªÒÔΪֻÓÐSELECTÓï¾äÊDzéѯ¡£Êµ¼ÊÉÏ£¬´øÓÐÈκÎWHEREÌõ¼þµÄDML(INSERT¡¢UPDATE¡¢DELETE)Óï¾äÖж¼°üº¬²éѯҪÇó£¬ÔÚºóÃæµÄÎÄÕÂÖУ¬µ±Ëµµ½²éѯʱ£¬²»Ò»¶¨Ö»ÊÇÖ¸SELECTÓï¾ä£¬Ò²ÓпÉÄÜÖ¸DMLÓï¾äÖеIJéѯ²¿·Ö¡£ÓÅ»¯Æ÷ÊÇËùÓйØÏµ ......

SQL ServerÀィORACLEÁ´½Ó·þÎñÆ÷µÄͼ½â

 Ê×ÏȼÆËã»úÉϱØÐë°²×°oracle£¬²¢ÅäÖú÷þÎñÃû
  °²×°oracleµÄ¹ý³ÌÖÐÒ»°ã»áÒªÇó½¨Á¢Ò»¸öÊý¾Ý¿â£¬Ò²¿ÉÒÔÖ®ºóÔÙ´´½¨
Õâ¸öºóÃæÓÐÒ»¸ö Êý¾Ý¿âÅäÖÃÖúÀí £¨´´½¨ÐÞ¸ÄÊý¾Ý¿âµÄ£¬Ò»°ãÃÜÂë´´½¨ÒªÇó×Öĸ¿ªÍ·£¬´óÓÚ7λɶµÄ£©ºÍÒ»¸önetÅäÖÃÖúÀí£¨Ìí¼Ó»òÕßÐÞ¸ÄÒ»¸öÊý¾Ý¿â·þÎñÃû£©£¬Ò»°ãÓÃplsql developerÔ¶³Ì²Ù×÷oracleÊý¾Ý¿â ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ