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£¬ÈÕÖ¾±àдÆ÷¾Í±ØÐ뿪ʼ¹¤×÷¡£ÈÕÖ¾±àдÆ÷µÄ¹¤×÷Íê³Éºó£¬ ÈÕÖ¾¹ÜÀíÆ÷½«»áÊÕµ½Ò»¸öдÈë³É¹¦µÄÐźţ¬½ø¶ø¼¤»îËùÓÐÕýÔڵȴýÈÕÖ¾»º´æˢеÄËùÓнø³Ì£¬ÒÔ¼Ì
Ïà¹ØÎĵµ£º
±È·½ËµÔÚ²éѯ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Óï¾äÖ®·ÖÎöº¯Êý--row_number() /rank()/dense_rank
Oracle·ÖÎöº¯ÊýRANK(),ROW_NUMBER(),LAG()µÈµÄʹÓ÷½·¨
ROW_NUMBER() OVER (PARTITION BY COL1 ORDER BY COL2)
±íʾ¸ù¾ÝCOL1·Ö×飬ÔÚ·Ö×éÄÚ²¿¸ù¾Ý COL2ÅÅÐò
¶øÕâ¸öÖµ¾Í±íʾÿ×éÄÚ²¿ÅÅÐòºóµÄ˳Ðò±àºÅ£¨×éÄÚÁ¬ÐøµÄΨһµÄ£©
RANK() ÀàËÆ£¬²»¹ýRANK ÅÅÐòµÄÊ ......
Ìá¸ßÊý¾Ý¿âÐÔÄܵķ½Ê½ÓÐÁ½ÖÖ
Ò»¡¢Ò»ÖÖÊÇDBAͨ¹ý¶ÔÊý¾Ý¿âµÄ¸÷¸ö·½Ãæµ÷ÓÅ
µ÷ÕûÊý¾Ý¿â:¹²Ïí³Ø,java³Ø,¸ßËÙ»º´æ,´óÐͳØ,java³Ø
Õë¶ÔÓÚwindow²Ù×÷ϵͳ 32λ,oracleÄÚ´æÕ¼Óã¬×î´óΪ1.7G,³¬¹ýÔò²»×÷ÓÃ,Òò´ËÕ⼸ÏîÖµÖ®ºÍ²»Ó¦³¬¹ý1.7G
Ä¿Ç°¸÷³Ø²ÎÊýΪ:
......
1¡¢½Ø¶ÏÈÕÖ¾£º
backup log Êý¾Ý¿â with no_log
»ò£º
Çå¿ÕÈÕÖ¾
DUMP TRANSACTION ¿âÃû WITH NO_LOG
2¡¢ & ......
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 ......