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

SQL SERVER ¾¿¾¹Ê²Ã´Ê±ºòдÈÕÖ¾£¿

×òÌì¿´µ½ÍøÉÏÓÐÒ»¸ö¹ØÓÚSQL SERVER ¿Î¼þ£¬±ãËæÊÖÏÂÔØÁËÏÂÀ´¿´¿´Ö÷Òª½²ÁËЩʲôÄÚÈÝ£¬ÓÚÊÇ¿´µ½ÁËÏÂÃæÁ½¸öPPTÒ³Ãæ
   

    ÓÉÓÚµÚÒ»ÕÅPPTÉϵÄÄÚÈݲ»Ì«×¼È·£¨ÈÕÖ¾ÎļþÖÐûÓГÈÕÖ¾Ò³”µÄ¸ÅÄֻÓÐVLFµÄ¸ÅÄ¿ÉÄÜÊÇÎÒÃǶԓÊý¾ÝÒ³”µÄ¸ÅÄîÌ«Éî¿ÌÁË£¬Òò´ËŪÁËÒÔ“ÈÕÖ¾Ò³”µÄ¸ÅÄî³öÀ´£¬¶øPPTÖÐ˵ÏȸüиßËÙ»º³åÇøÖеÄÊý¾ÝÒ³£¬È»ºó½«ÊÂÎñÈÕ־дÈëµ½“ÈÕÖ¾Ò³”£¬ºÜÈÝÒ×ÈÃÈËÀí½â³ÉÏȸü¸Ä¸ßËÙ»º³åÇø£¬È»ºó½«ÈÕ־дÈëµ½´ÅÅÌÉϵēÈÕÖ¾Ò³”£©,ÔÙ¼ÓÉÏÎÒ¿´PPTʱ±È½Ï"àñàð"(Ö»¿´µ½Ç°Ò»ÕÅPPT,ûÓÐÍùºó·­Á½Ï¿´ºóÃæÒ»ÕÅPPT).Òò´ËÎÒ¾õµÃPPTµÄ×÷ÕßÔÚÈÕÖ¾µÄдÈë˳ÐòÉÏÓÐÎÊÌâ.Ë÷ÐÔ²éÁËÒ»ÏÂ×ÊÁÏ,È»ºó±È½ÏÉîÈëµÄ˼¿¼ÁËÈÕÖ¾µÄдÈë˳ÐòÎÊÌâ,ͬʱҲ¾ÀÕýÁËһЩ×Ô¼ºÒÔÍùµÄ²»ÕýÈ·Àí½â.
    ¸ÃÎÄÖ÷Òª°üº¬ÒÔÏÂÄÚÈÝ:
     1.SQL SERRVER ÈÕÖ¾¹ÜÀíÆ÷µÄ´óÖ¹¤×÷ÄÚÈÝÓëÔ­Àí.
     2.ʵÀý̽¾¿SQL SERVER ÊÂÎñÈÕÖ¾µÄ²úÉúÓëдÈë´ÅÅÌ´ÅÅÌ. 
     3.һЩÆäËüµÄÏà¹Ø˼¿¼.
    µÚÒ»²¿·Ö:SQL SERVER ÈÕÖ¾¹ÜÀíÆ÷µÄ´óÖ¹¤×÷Ô­Àí.
    ÈÕÖ¾¹ÜÀíÆ÷³Ðµ£×ÅÊÂÎñÈÕÖ¾µÄ±àÅÅÓëдÈ빤×÷¡£Ëüά»¤×ÅÒ»¸ö»ò¶à¸ö±»³Æ֮Ϊ“ÈÕÖ¾»º´æ”µÄÁ¬ÐøµÄרÓÃÄÚ´æÇøÓò¡£ÓÉÓÚSQL SERVER ÊÂÎñÈÕÖ¾±ØÐë°´ÕÕÒ»¶¨µÄ¸ñʽдÈëµ½ÈÕÖ¾ÎļþÖУ¬Òò´ËÈÕÖ¾»º´æÖеŦÄÜÖ®Ò»¾ÍÊÇÓÃÀ´±àÅÅÈÕÖ¾µÄ¸ñʽ¡£¶øµ±Ò»¸öÈÕÖ¾»º´æÇøÓò±»Õ¼ÂúµÄʱºò£¬»¹ÓÐÒ»¸ö»ò¶à¸öÈÕÖ¾»º´æÇøÓò¿ÉÒÔ±»ÓÃÀ´±£´æвúÉúµÄÈÕÖ¾¼Ç¼¡£ 
    Æä´Î£¬ÈÕÖ¾¹ÜÀíÆ÷ά»¤×ÅÁ½¸öÈÕÖ¾»º´æ¶ÓÁУ¬Ò»¸öflushQueue,ÁíÒ»¸öÊÇfreeQueue¡£ÆäÖÐflushQueue°üº¬µÄÊǵȴý±»Ë¢Ðµ½ÈÕÖ¾Îļþ£¨ÎïÀí´ÅÅÌ£©µÄÈÕÖ¾»º´æ£»freeQueue°üº¬µÄÊÇÒѾ­±»Ë¢Ð²¢ÇÒ¿ÉÒÔ±»ÔÙ´ÎʹÓõÄÈÕÖ¾»º´æ¡£
    ¶øÈÕÖ¾µÄˢй¤×÷Ö÷ÒªÒ»¸ö±»³Æ֮Ϊ“ÈÕÖ¾±àдÆ÷”µÄÏß³ÌÀ´¸ºÔð£¬Ëü½«ÒÀ´Î±éÀú flushQueue£¬Ò»´Î½ö½«Ò»¸öµ±Ç°µÄÈÕÖ¾»º´æÖеÄÄÚÈÝдÈëµ½´ÅÅÌÉÏ¡£
    ¶øÈÕÖ¾±àдÆ÷µÄˢй¤×÷ÓÉʲôÀ´´¥·¢ÄØ£¿µ±Ò»¸öÊÂÎñ±»Ìύʱ»òÕßÈÕÖ¾»º´æ±»Õ¼Âúʱ£¬µ±Ç°µÄÈÕÖ¾»º´æ¾Í±»·ÅÈëflushQueue£¬ÈÕÖ¾±àдÆ÷¾Í±ØÐ뿪ʼ¹¤×÷¡£ÈÕÖ¾±àдÆ÷µÄ¹¤×÷Íê³Éºó£¬ ÈÕÖ¾¹ÜÀíÆ÷½«»áÊÕµ½Ò»¸öдÈë³É¹¦µÄÐźţ¬½ø¶ø¼¤»îËùÓÐÕýÔڵȴýÈÕÖ¾»º´æˢеÄËùÓнø³Ì£¬ÒÔ¼Ì


Ïà¹ØÎĵµ£º

SQLÊÖ¹¤×¢Èë´óÈ«

±È·½ËµÔÚ²éѯidÊÇ50µÄÊý¾Ýʱ£¬Èç¹ûÓû§´«½üÀ´µÄ²ÎÊýÊÇ50 and 1=1£¬Èç¹ûûÓÐÉèÖùýÂ˵Ļ°£¬¿ÉÒÔÖ±½Ó²é³öÀ´£¬SQL ×¢ÈëÒ»°ãÔÚASP³ÌÐòÖÐÓöµ½×î¶à£¬
¿´¿´ÏÂÃæµÄ
1.ÅжÏÊÇ·ñÓÐ×¢Èë
;and 1=1
;and 1=2
2.³õ²½ÅжÏÊÇ·ñÊÇmssql
;and user>0
3.ÅжÏÊý¾Ý¿âϵͳ
;and (select count(*) from sysobjects)>0 mssql ......

¸ßЧµÄSQLÓï¾äÖ®·ÖÎöº¯Êý

¸ßЧµÄSQLÓï¾äÖ®·ÖÎöº¯Êý--row_number() /rank()/dense_rank
Oracle·ÖÎöº¯ÊýRANK(),ROW_NUMBER(),LAG()µÈµÄʹÓ÷½·¨
ROW_NUMBER() OVER (PARTITION BY COL1 ORDER BY COL2)
±íʾ¸ù¾ÝCOL1·Ö×飬ÔÚ·Ö×éÄÚ²¿¸ù¾Ý COL2ÅÅÐò
¶øÕâ¸öÖµ¾Í±íʾÿ×éÄÚ²¿ÅÅÐòºóµÄ˳Ðò±àºÅ£¨×éÄÚÁ¬ÐøµÄΨһµÄ£©
RANK() ÀàËÆ£¬²»¹ýRANK ÅÅÐòµÄÊ ......

SQL Óï¾äÓÅ»¯

Ìá¸ßÊý¾Ý¿âÐÔÄܵķ½Ê½ÓÐÁ½ÖÖ
Ò»¡¢Ò»ÖÖÊÇDBAͨ¹ý¶ÔÊý¾Ý¿âµÄ¸÷¸ö·½Ãæµ÷ÓÅ
   µ÷ÕûÊý¾Ý¿â:¹²Ïí³Ø,java³Ø,¸ßËÙ»º´æ,´óÐͳØ,java³Ø
   Õë¶ÔÓÚwindow²Ù×÷ϵͳ 32λ,oracleÄÚ´æÕ¼Óã¬×î´óΪ1.7G,³¬¹ýÔò²»×÷ÓÃ,Òò´ËÕ⼸ÏîÖµÖ®ºÍ²»Ó¦³¬¹ý1.7G
   Ä¿Ç°¸÷³Ø²ÎÊýΪ:
      ......

ɾ³ýsql 2005 ÈÕÖ¾

1¡¢½Ø¶ÏÈÕÖ¾£º  
  backup   log   Êý¾Ý¿â   with   no_log  
   
  »ò£º  
  Çå¿ÕÈÕÖ¾  
  DUMP     TRANSACTION     ¿âÃû     WITH     NO_LOG    
   
  2¡¢ & ......

oracle sqlÓÅ»¯Ö®¶à±íÁ¬½ÓÓÅ»¯


Use equality first.
ʹÓõÈÁ¬½Ó
Use range operators only where equality does not apply.
Ö»ÓÐÔÚµÈÁ¬½Ó²»¿ÉÓõÄÇé¿öÏÂÊÂÓÉÇø¼äÁ¬½Ó
Avoid use of negatives in the form of !=
or NOT.
±ÜÃâʹÓà £¡= »òÕß not
Avoid LIKE pattern matching.
±ÜÃâʹÓà LIKEÆ¥Åä
Try to retrieve specific rows and in small n ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ