Ò׽ؽØͼÈí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

SQL¡¢PL/SQLѧϰ±Ê¼Ç


 
1£®SQL²¢Ðвéѯ
alter session enable parallel dml execute immediate 'alter session enable parallel dml'; --Ð޸ĻỰ²¢ÐÐDML      select /*+parallel(a,4)*/ * from table_name a       select /*+parallel(a,8)*/ * from table_name a       select /*+parallel(a,4) parallel(b,4) parallel(c,4)*/ a.*,b.*,c.* from table_name<st1:chmetcnv w:st="on" unitname="a" sourcevalue="1" hasspace="True" negative="False" numbertype="1" tcsc="0"><st1:address w:st="on" unitname="a" sourcevalue="1" hasspace="True" negative="False" numbertype="1" tcsc="0">1 a</st1:address></st1:chmetcnv>,table_name2 b,table_name c       insert /*+parallel(t,4)*/ into table_name t                       insert /*+parallel(t,8)*/ into table_name t                       /*+parallel(t,8)*/ ²¢Ðд¦Àí£¬Ò»°ãΪCPUµÄ±¶ÊýÈ磺4£¬8µÈ,ÔÚÖ´ÐÐÀàÐÍSQL±ØÐëÏÈÔËÐÐ:alter session enable parallel dml  
2£®É¾³ý±í·ÖÇøÊý¾Ý
alter table masamk.tb_mk_sc_user_mon truncate partition mk_user_mon_'||trim(iv_month) ɾ³ýÖ¸¶¨±í·ÖÇøÊý¾Ý     
3£®minus(²î¼¯)Óëintersect(½»¼¯)
minus      Ö¸ÁîÊÇÔËÓÃÔÚÁ½¸ö SQL Óï¾äÉÏ¡£ËüÏÈÕÒ³öµÚÒ»¸ö SQL Óï¾äËù²úÉúµÄ½á¹û£¬È»ºó¿´ÕâЩ½á¹ûÓÐûÓÐÔÚµÚ¶þ¸ö SQL Óï¾äµÄ½á¹ûÖÐ,Èç¹ûÓеĻ°£¬ÄÇÕâÒ»±Ê×ÊÁϾͱ»È¥³ý£¬¶ø²»»áÔÚ×îºóµÄ½á¹ûÖгöÏÖ; Èç¹ûµÚ¶þ¸ö SQL Óï¾äËù²úÉúµÄ½á¹û²¢Ã»ÓдæÔÚÓÚµÚÒ»¸ö SQL Óï¾äËù²úÉúµÄ½á¹ûÄÚ£¬ÄÇÕâ±Ê×ÊÁϾͱ»Å×Æú¡£ intersect Ö¸ÁîÊÇÔËÓÃÔÚÁ½¸öSQLÓï¾äÉÏ£¬Èç¹ûÁ½¸öSQLÓï¾äµÄ¼Ç¼ÍêÈ«ÏàͬÔòÏÔʾÏàÓ¦¼Ç¼£¬·ñÔò½«²»ÔÚ½á¹ûÖгöÏÖ
4£®Order by ÖÐµÄ nulls last
order by area_code,bill_month nulls last --nulls last ½«ÅÅÐò×Ö¶ÎΪnull¼Ç¼·ÅÔÚ×îºóÃæ      
5£®nvlµÄ¼¸¸ö²»Í


Ïà¹ØÎĵµ£º

Ò»²½Ò»²½Ñ§Linq to sqlϵÁÐÎÄÕÂ

ÏÖÔÚLinq to sqlµÄ×ÊÁÏ»¹²»ÊǺܶ࣬±¾ÈËˮƽÓÐÏÞ£¬Èç¹ûÓдí»òÕßÎóµ¼ÇëÖ¸³ö£¬Ð»Ð»¡£
Ò»²½Ò»²½Ñ§Linq to sql£¨Ò»£©£ºÔ¤±¸ÖªÊ¶
Ò»²½Ò»²½Ñ§Linq to sql£¨¶þ£©£ºDataContextÓëʵÌå 
Ò»²½Ò»²½Ñ§Linq to sql£¨Èý£©£ºÔöɾ¸Ä
Ò»²½Ò»²½Ñ§Linq to sql£¨ËÄ£©£º²éѯ¾ä·¨
Ò»²½Ò»²½Ñ§Linq to sql£¨Î壩£º´æ´¢¹ý³Ì
Ò»²½Ò»²½ ......

ÇóÖúSQL SERVER 2008Á¬½ÓÎÊÌâ

²âÊÔ»útest°²×°µÄÊÇwindows server2008+sql server 2008£¬Êý¾Ý¿â°²×°³É¹¦¡£¿ÉÒÔÁ¬½Ó¾ÖÓòÍøÄÚÆäËû»úÆ÷µÄÊý¾Ý¿â£¨ÆäËû»úÆ÷µÄÊý¾Ý¿âΪSQL 2005£©¡£µ«ÊÇÍøÄÚÆäËû»úÆ÷·ÃÎÊtestʱ£¬ÎÞ·¨Á¬½Ó£¬±¨´í¡£ÐÅϢΪ£ºÔÚ½¨Á¢Óë·þÎñÆ÷µÄÁ¬½Óʱ³ö´í¡£ÔÚÁ¬½Óµ½SQL SERVER 2005ʱ£¬ÔÚĬÈϵÄÉèÖÃÏÂSQL SERVER ²»ÔÊÐí½øÐÐÔ¶³ÌÁ¬½Ó¿ÉÄܻᵼÖ´Îʧ°Ü ......

SQL SERVER£ºselect ×Ö·û´®Æ´½ÓÎÊÌâ

Ò»¡¢ÎÊÌâ
select UserID,LastName,FirstName,UserName from SYSUser
UserID LastName FirstName UserName
------------------------------------------------------
1      A        B        C
2  &nb ......

SQLͳ¼Æ´óÈ«ÊÕ²Ø°æ ¸öÈËʹÓÃ

ÎÄÕÂÀ´Ô´£ºIT¹¤³Ì¼¼ÊõÍø£¬ È«ÎÄÁ´½Ó£ºhttp://www.systhinker.com/html/81/n-11481.html
1.¼ÆËãÿ¸öÈ˵Ä×ܳɼ¨²¢ÅÅÃû
select name,sum(score) as allscore from stuscore group by name order by allscore
2.¼ÆËãÿ¸öÈ˵Ä×ܳɼ¨²¢ÅÅÃû
select distinct t1.name,t1.stuid,t2.allscore from stuscore t1,( select st ......

ÎåÖÖÌá¸ß SQL ÐÔÄܵķ½·¨

±¾ÎĽÚÑ¡×ÔMSDNµÄÎÄÕ¡¶ÎåÖÖÌá¸ß SQL ÐÔÄܵķ½·¨¡·£¬Ìá³öÈçºÎÌá¸ß»ùÓÚSQL ServerÓ¦ÓóÌÐòµÄÔËÐÐЧÂÊ£¬·Ç³£ÖµµÃÍƼö¡£¶ÔһЩTrafficºÜ¸ßµÄÓ¦ÓÃϵͳ¶øÑÔ£¬ÈçºÎÌá¸ßºÍ¸Ä½øSQLÖ¸ÁÊǷdz£ÖØÒªµÄ£¬Ò²ÊÇÒ»¸öºÜºÃµÄÍ»ÆƵ㡣
*ÎÄÕÂÖ÷Òª°üÀ¨ÈçÏÂһЩÄÚÈÝ£¨Èç¸ÐÐËȤ£¬ÇëÖ±½Ó·ÃÎÊÏÂÃæµÄURLÔĶÁÍêÕûµÄÖÐÓ¢ÎÄÎĵµ£©£º
1, ´Ó INSERT ·µ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ