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 = '!')
Ïà¹ØÎĵµ£º
create PROCEDURE pagelist
@tablename nvarchar(50),
@fieldname nvarchar(50)='*',
@pagesize int output,--ÿҳÏÔʾ¼Ç¼ÌõÊý
@currentpage int output,--µÚ¼¸Ò³
@orderid nvarchar(50),--Ö÷¼üÅÅÐò
@sort int,--ÅÅÐò·½Ê½£¬1±íʾÉýÐò£¬0±íʾ½µÐòÅÅÁÐ
......
RowidµÄ¸ÅÄ
rowidÊÇÒ»¸öαÁУ¬¼ÈÈ»ÊÇαÁУ¬ÄÇôÕâ¸öÁоͲ»ÊÇÓû§¶¨Ò壬¶øÊÇϵͳ×Ô¼º¸ø¼ÓÉϵġ£¶Ôÿ¸ö±í¶¼ÓÐÒ»¸örowidµÄαÁУ¬µ«ÊDZíÖв¢²»ÎïÀí´æ´¢ROWIDÁеÄÖµ¡£²»¹ýÄã¿ÉÒÔÏñʹÓÃÆäËüÁÐÄÇÑùʹÓÃËü£¬µ«ÊDz»ÄÜɾ³ý¸ÄÁУ¬Ò²²»ÄܶԸÃÁеÄÖµ½øÐÐÐ޸ġ¢²åÈë¡£Ò»µ©Ò»ÐÐÊý¾Ý²åÈëÊý¾Ý¿â£¬ÔòrowidÔÚ¸ÃÐеÄÉúÃüÖÜÆÚÄÚÊÇΨһµÄ£¬¼´ ......
Visual C#Öж¯Ì¬²Ù×÷SQL ServerÊý¾Ý¿â £¨1£©
·¢²¼Ê±¼ä£º2003.01.14 10:09 À´Ô´£ºÈüµÏÍø ×÷ÕߣºÍõ¿Ã÷
ÔÚ±àдÊý¾Ý¿âÓ¦ÓóÌÐòµÄʱºò£¬ÎÒÃÇ¿ÉÒÔͨ¹ýSQLÓï¾äÀ´¶¯Ì¬´´½¨¡¢ÐÞ¸ÄÊý¾Ý¿âÒÔ¼°ÆäÖеĶÔÏó¡£±¾ÎÄÎÒ¾ÍÏò´ó¼Ò½éÉÜÈçºÎÔËÓÃVisual C#À´¶¯Ì¬²Ù×÷SQL ServerÊý¾Ý¿ ......
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^ ......