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 = '!')
Ïà¹ØÎĵµ£º
ÔÚWin7ϰ²×°SQL2005¿ª·¢°æ£¬°²×°SQL Native ClientʱÌáʾ°²×°Öжϣ¬Ã»ÓÐÔÚÒ⣬ȻºóÔÚ°²×°SQL ServerʱÓÖÌáʾ“[Microsoft][SQL Native Client]¿Í»§¶Ë²»Ö§³Ö¼ÓÃÜ.SQL Server °²×°³ÌÐòÎÞ·¨Á¬½Óµ½Êý¾Ý¿â·þÎñ½øÐзþÎñÆ÷ÅäÖÃ.”Ð¶ÔØSQL Native ClientÖØÐ°²×°£¬»¹ÊÇÖжϣ¬ÐÞ¸´£¬Ò²Öжϣ¬ÔÙÐ¶ÔØ£¬ÇåÀí×¢²á±í£¬ÖØ× ......
ÔÚSQL ServerÀィMysqlºÍOracleÊý¾Ý¿âÁ´½Ó»¹ÊDZȽÏÈÝÒ׵ģºÎÒÃÇÏÈÔÚ·þÎñÆ÷Éϰ²×°MysqlºÍOracleÊý¾Ý¿âÏà¹ØµÄODBCÇý¶¯³ÌÐò£¬ÔÚ[¹ÜÀí¹¤¾ß]->[Êý¾ÝÔ´(ODBC)] ÉèÖÃϵͳDSN£¬ÈçÏÂͼ:
ÉèÖúÃÁËÒÔºó£¬ÎÒÃÇ¿ÉÒÔÓÃSQL Server×Ô´øµÄµ¼³öºÍµ¼È빤¾ßÀ´Êµ ......
Î壺 ORACLEµÄÖ´Ðмƻ®
±³¾°ÖªÊ¶£ºÎªÁ˸üºÃµÄ½øÐÐÏÂÃæµÄÄÚÈÝÎÒÃDZØÐëÁ˽âһЩ¸ÅÄîÐÔµÄÊõÓ
¹²ÏísqlÓï¾ä
ΪÁ˲»Öظ´½âÎöÏàͬµÄSQLÓï¾ä(ÒòΪ½âÎö²Ù×÷±È½Ï·Ñ×ÊÔ´£¬»áµ¼ÖÂÐÔÄÜϽµ)£¬ÔÚµÚÒ»´Î½âÎöÖ®ºó£¬ORACLE½«SQLÓï¾ä¼°½âÎöºóµÃµ½µÄÖ´Ðмƻ®´æ·ÅÔÚÄÚ´æÖС£Õâ¿éλÓÚϵͳȫ¾ÖÇøÓòSGA(system global are ......
bit£º0»ò1µÄÕûÐÍÊý×Ö
int£º´Ó-2^31(-2,147,483,648)µ½2^31(2,147,483,647)µÄÕûÐÍÊý×Ö
smallint£º´Ó-2^15(-32,768)µ½2^15(32,767)µÄÕûÐÍÊý×Ö
tinyint£º´Ó0µ½255µÄÕûÐÍÊý×Ö
decimal£º´Ó-10^38µ½10^38-1µÄ¶¨¾«¶ÈÓëÓÐЧλÊýµÄÊý×Ö
numeric£ºdecimalµÄͬÒå´Ê
money£º´Ó-2^63(-922,337,203,685,477.5808)µ½2^ ......