SQL CASEµÄÓ÷¨£¬±ÈÏëÏóÖеÄÇ¿´ó
±íÈçÏÂ
Ò»ÌõÓï¾äÏÔʾËùÓдóÓÚ25ËêºÍϵÄÈË£¬ÒÔÉϵÄÈËÏÔ'´óÁä'
select case when age>25 then '´óÁä' else 'СÁä' end as ÄêÁä¼¶±ð,count(*) as ÈËÊý from infor group by case when age>25 then '´óÁä' else 'СÁä' end
Ïà¹ØÎĵµ£º
¡¡¡¡Ïò±íÖÐÔö¼ÓÒ»¸ö varchar ÁУº
¡¡¡¡ALTER TABLE distributors ADD COLUMN address varchar(30);
¡¡¡¡´Ó±íÖÐɾ³ýÒ»¸ö×ֶΣº
¡¡¡¡ALTER TABLE distributors DROP COLUMN address RESTRICT;
¡¡¡¡ÔÚÒ»¸ö²Ù×÷ÖÐÐÞ¸ÄÁ½¸öÏÖÓÐ×ֶεÄÀàÐÍ£º
¡¡¡¡ALTER TABLE distributors
¡¡¡¡ALTER COLUMN address TYPE varchar(80),
......
1¡£select * from v$nls_parameters
²éѯnlsµÄ²ÎÊý£¬»ñµÃÊý¾Ý¿â·þÎñÆ÷¶ËµÄ×Ö·û±àÂë
NLS_LANGUAGE
NLS_CHARACTERSET
2¡£Ð޸ı¾µØ»·¾³±äÁ¿£¬ÉèÖÃ
NLS_LANG = SIMPLIFIED CHINESE.ZHS16GBK //Õâ¸öÊÇÎÒÃǵÄÊý¾Ý¿â×Ö·û±àÂë
NLS_LANG¸ñʽ£º
NLS_LANG = language_territory.char ......
ʹÓà TRUNCATE TABLE ɾ³ýËùÓÐÐÐ
ÈôҪɾ³ý±íÖеÄËùÓÐÐУ¬Ôò TRUNCATE TABLE Óï¾äÊÇÒ»ÖÖ¿ìËÙ¡¢ÓÐЧµÄ·½·¨¡£TRUNCATE TABLE Óë²»º¬ WHERE ×Ó¾äµÄ DELETE Óï¾äÀàËÆ¡£µ«ÊÇ£¬TRUNCATE TABLE Ëٶȸü¿ì£¬²¢ÇÒʹÓøüÉÙµÄϵͳ×ÊÔ´ºÍÊÂÎñÈÕÖ¾×ÊÔ´¡£
Óë DELETE Óï¾äÏàͬ£¬Ê¹Óà TRUNCATE TABLE Çå¿ÕµÄ±íµÄ¶¨ÒåÓëÆäË÷ÒýºÍÆäËû¹ØÁª¶ÔÏóÒ ......
1¡¢Datediff£º
1.1Ëã³öÈÕÆÚ²î£º
1.access: datediff('d',fixdate,getdate())
2.sqlserver: datediff(day,fixdate,getdate())
ACCESSʵÀý£º select * from table where data=datediff('d',fixdate,getdate())
sqlserverʵÀý£º select * from ......
×öÊý¾Ý¿â¿ª·¢»ò¹ÜÀíµÄÈ˾³£Òª´´½¨´óÁ¿µÄ²âÊÔÊý¾Ý£¬¶¯²»¶¯¾ÍÐèÒªÉÏÍòÌõ£¬Èç¹ûÒ»ÌõÒ»ÌõµÄ¼È룬ÄÇ»áÀË·Ñ´óÁ¿µÄʱ¼ä£¬±¾ÎĽéÉÜÁËOracleÖÐÈçºÎͨ¹ýÒ»ÌõSQL¿ìËÙÉú³É´óÁ¿µÄ²âÊÔÊý¾ÝµÄ·½·¨¡£
²úÉú²âÊÔÊý¾ÝµÄSQLÈçÏ£º
SQL> select rownum as id,
2 &nbs ......