Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö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±íʾ½µÐòÅÅÁÐ ......

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

RowidµÄ¸ÅÄ
rowidÊÇÒ»¸öαÁУ¬¼ÈÈ»ÊÇαÁУ¬ÄÇôÕâ¸öÁоͲ»ÊÇÓû§¶¨Ò壬¶øÊÇϵͳ×Ô¼º¸ø¼ÓÉϵġ£¶Ôÿ¸ö±í¶¼ÓÐÒ»¸örowidµÄαÁУ¬µ«ÊDZíÖв¢²»ÎïÀí´æ´¢ROWIDÁеÄÖµ¡£²»¹ýÄã¿ÉÒÔÏñʹÓÃÆäËüÁÐÄÇÑùʹÓÃËü£¬µ«ÊDz»ÄÜɾ³ý¸ÄÁУ¬Ò²²»ÄܶԸÃÁеÄÖµ½øÐÐÐ޸ġ¢²åÈë¡£Ò»µ©Ò»ÐÐÊý¾Ý²åÈëÊý¾Ý¿â£¬ÔòrowidÔÚ¸ÃÐеÄÉúÃüÖÜÆÚÄÚÊÇΨһµÄ£¬¼´ ......

C#²Ù×÷SQL ServerÊý¾Ý¿â(ת)


Visual C#Öж¯Ì¬²Ù×÷SQL ServerÊý¾Ý¿â £¨1£©
 
·¢²¼Ê±¼ä£º2003.01.14 10:09     À´Ô´£ºÈüµÏÍø    ×÷ÕߣºÍõ¿­Ã÷
ÔÚ±àдÊý¾Ý¿âÓ¦ÓóÌÐòµÄʱºò£¬ÎÒÃÇ¿ÉÒÔͨ¹ýSQLÓï¾äÀ´¶¯Ì¬´´½¨¡¢ÐÞ¸ÄÊý¾Ý¿âÒÔ¼°ÆäÖеĶÔÏó¡£±¾ÎÄÎÒ¾ÍÏò´ó¼Ò½éÉÜÈçºÎÔËÓÃVisual C#À´¶¯Ì¬²Ù×÷SQL ServerÊý¾Ý¿ ......

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^ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ