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 = '!')
Ïà¹ØÎĵµ£º
¶þ£ºÓÐЧµÄÓ¦ÓÃÉè¼Æ
ÎÒÃÇͨ³£½«×î³£ÓõÄÓ¦Ó÷ÖΪ2ÖÖÀàÐÍ£ºÁª»úÊÂÎñ´¦ÀíÀàÐÍ(OLTP)£¬¾ö²ßÖ§³Öϵͳ(DSS)¡£
Áª»úÊÂÎñ´¦Àí(OLTP)
¸ÃÀàÐ͵ÄÓ¦ÓÃÊǸßÍÌÍÂÁ¿£¬²åÈë¡¢¸üС¢É¾³ý²Ù×÷±È½Ï¶àµÄϵͳ£¬ÕâЩϵͳÒÔ²»¶ÏÔö³¤µÄ´óÈÝÁ¿Êý¾ÝÎªÌØÕ÷£¬ËüÃÇÌṩ¸ø³É°ÙÓû§Í¬Ê±´æÈ¡£¬µäÐ͵ÄOLTPϵͳÊǶ©Æ±ÏµÍ³£¬ÒøÐеÄÒµÎñϵͳ£¬¶©µ¥ÏµÍ³¡£OT ......
ÔÚWin7ϰ²×°SQL2005¿ª·¢°æ£¬°²×°SQL Native ClientʱÌáʾ°²×°Öжϣ¬Ã»ÓÐÔÚÒ⣬ȻºóÔÚ°²×°SQL ServerʱÓÖÌáʾ“[Microsoft][SQL Native Client]¿Í»§¶Ë²»Ö§³Ö¼ÓÃÜ.SQL Server °²×°³ÌÐòÎÞ·¨Á¬½Óµ½Êý¾Ý¿â·þÎñ½øÐзþÎñÆ÷ÅäÖÃ.”Ð¶ÔØSQL Native ClientÖØÐ°²×°£¬»¹ÊÇÖжϣ¬ÐÞ¸´£¬Ò²Öжϣ¬ÔÙÐ¶ÔØ£¬ÇåÀí×¢²á±í£¬ÖØ× ......
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), ......
¡¡¡¡±¾ÎÄʾÀýÔ´´úÂë»òËØ²ÄÏÂÔØ
¡¡¡¡±¾½ÚµÄÄÚÈÝ£º
¡¡¡¡ÈçºÎÔÚInfoPathÖÐʹÓÃÊý¾ÝÁ¬½ÓÀ´´ÓSQL ServerÊý¾Ý¿âÖлñÈ¡Êý¾Ý
¡¡¡¡ÈçºÎͨ¹ý´úÂëÀ´ÐÞ¸ÄÊý¾ÝÁ¬½ÓÖеÄSQL²éѯ
¡¡¡¡ÔÚ¿ªÊ¼Éè¼ÆInfoPath±íµ¥Ö®Ç°£¬ÏÈ×¼±¸Ò»¸öÊý¾Ý¿â£¬InfoPathÖ§³ÖÁ½ÖÖÊý¾Ý¿âÁ¬½Ó£º
¡¡¡¡Microsoft Office AccessÊý¾Ý¿â£¨.mdbÎļþ»ò.accdbÎļþ£©
¡¡¡ ......
×î½üÓÐÅóÓÑÓöµ½Ê¡ÊеÄÎÊÌ⣬ÏëÏë×Ô¼º½ñºóÒ²ÓпÉÄÜ»áÓöµ½£¬ËùÒÔ¾Í×Ô¼ºÔÚÍøÉÏдд£¬ËÑËÑ£¬Ö÷ÒªÊǶÔ×Ô¼º½ñºóÓвο¼
--´´½¨Êý¾Ý¿â
create database NationalAll
Go
--ʹÓÃNationalAllÊý¾Ý¿â
use NationalAll
Go
--´´½¨Ê¡¼¶±í
Create Table Province
(
ProID int primary key not null,
ProName nvarchar(50) n ......