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£¨¶þ£©£ºDataContextÓëʵÌå
Ò»²½Ò»²½Ñ§Linq to sql£¨Èý£©£ºÔöɾ¸Ä
Ò»²½Ò»²½Ñ§Linq to sql£¨ËÄ£©£º²éѯ¾ä·¨
Ò»²½Ò»²½Ñ§Linq to sql£¨Î壩£º´æ´¢¹ý³Ì
Ò»²½Ò»²½ ......
²âÊÔ»útest°²×°µÄÊÇwindows server2008+sql server 2008£¬Êý¾Ý¿â°²×°³É¹¦¡£¿ÉÒÔÁ¬½Ó¾ÖÓòÍøÄÚÆäËû»úÆ÷µÄÊý¾Ý¿â£¨ÆäËû»úÆ÷µÄÊý¾Ý¿âΪSQL 2005£©¡£µ«ÊÇÍøÄÚÆäËû»úÆ÷·ÃÎÊtestʱ£¬ÎÞ·¨Á¬½Ó£¬±¨´í¡£ÐÅϢΪ£ºÔÚ½¨Á¢Óë·þÎñÆ÷µÄÁ¬½Óʱ³ö´í¡£ÔÚÁ¬½Óµ½SQL SERVER 2005ʱ£¬ÔÚĬÈϵÄÉèÖÃÏÂSQL SERVER ²»ÔÊÐí½øÐÐÔ¶³ÌÁ¬½Ó¿ÉÄܻᵼÖ´Îʧ°Ü ......
Ò»¡¢ÎÊÌâ
select UserID,LastName,FirstName,UserName from SYSUser
UserID LastName FirstName UserName
------------------------------------------------------
1 A B C
2 &nb ......
ÎÄÕÂÀ´Ô´£º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 ......
±¾ÎĽÚÑ¡×ÔMSDNµÄÎÄÕ¡¶ÎåÖÖÌá¸ß SQL ÐÔÄܵķ½·¨¡·£¬Ìá³öÈçºÎÌá¸ß»ùÓÚSQL ServerÓ¦ÓóÌÐòµÄÔËÐÐЧÂÊ£¬·Ç³£ÖµµÃÍƼö¡£¶ÔһЩTrafficºÜ¸ßµÄÓ¦ÓÃϵͳ¶øÑÔ£¬ÈçºÎÌá¸ßºÍ¸Ä½øSQLÖ¸ÁÊǷdz£ÖØÒªµÄ£¬Ò²ÊÇÒ»¸öºÜºÃµÄÍ»ÆƵ㡣
*ÎÄÕÂÖ÷Òª°üÀ¨ÈçÏÂһЩÄÚÈÝ£¨Èç¸ÐÐËȤ£¬ÇëÖ±½Ó·ÃÎÊÏÂÃæµÄURLÔĶÁÍêÕûµÄÖÐÓ¢ÎÄÎĵµ£©£º
1, ´Ó INSERT ·µ ......