SQL×¢È멶´È«½Ó´¥ ½ø½×ƪ
µÚÒ»½Ú¡¢SQL×¢ÈëµÄÒ»°ã²½Öè
Ê×ÏÈ£¬Åжϻ·¾³£¬Ñ°ÕÒ×¢Èëµã£¬ÅжÏÊý¾Ý¿âÀàÐÍ£¬ÕâÔÚÈëÃÅƪÒѾ½²¹ýÁË¡£
Æä´Î£¬¸ù¾Ý×¢Èë²ÎÊýÀàÐÍ£¬ÔÚÄÔº£ÖÐÖع¹SQLÓï¾äµÄÔò£¬°´²ÎÊýÀàÐÍÖ÷Òª·ÖΪÏÂÃæÈýÖÖ£º
(A) ID=49 ÕâÀà×¢ÈëµÄ²ÎÊýÊÇÊý×ÖÐÍ£¬SQLÓï¾äÔò´óÖÂÈçÏ£º
Select * from ±íÃû where
×Ö¶Î=49
×¢ÈëµÄ²ÎÊýΪID=49 And [²éѯÌõ¼þ]£¬¼´ÊÇÉú³ÉÓï¾ä£º
Select * from ±íÃû where ×Ö¶Î=49 And
[²éѯÌõ¼þ]
(B) Class=Á¬Ðø¾ç ÕâÀà×¢ÈëµÄ²ÎÊýÊÇ×Ö·ûÐÍ£¬SQLÓï¾äÔò´óÖ¸ÅÈçÏ£º
Select * from ±íÃû
where ×Ö¶Î=’Á¬Ðø¾ç’
×¢ÈëµÄ²ÎÊýΪClass=Á¬Ðø¾ç’ and [²éѯÌõ¼þ] and ‘’=’ £¬¼´ÊÇÉú³ÉÓï¾ä£º
Select *
from ±íÃû where ×Ö¶Î=’Á¬Ðø¾ç’ and [²éѯÌõ¼þ] and ‘’=’’
(C) ËÑË÷ʱû¹ýÂ˲ÎÊýµÄ£¬Èçkeyword=¹Ø¼ü×Ö£¬SQLÓï¾äÔò´óÖÂÈçÏ£º
Select * from ±íÃû
where ×Ö¶Îlike ’%¹Ø¼ü×Ö%’
×¢ÈëµÄ²ÎÊýΪkeyword=’ and [²éѯÌõ¼þ] and ‘%25’=’£¬
¼´ÊÇÉú³ÉÓï¾ä£º
Select * from ±íÃû where×Ö¶Îlike ’%’ and [²éѯÌõ¼þ] and ‘%’=’%’
½Ó×Å£¬½«²éѯÌõ¼þÌæ»»³ÉSQLÓï¾ä£¬²Â½â±íÃû£¬ÀýÈ磺
ID=49 And (Select Count(*) from Admin)>=0
Èç¹ûÒ³Ãæ¾ÍÓëID=49µÄÏàͬ£¬ËµÃ÷¸½¼ÓÌõ¼þ³ÉÁ¢£¬¼´±íAdmin´æÔÚ£¬·´Ö®£¬¼´²»´æÔÚ£¨ÇëÀμÇÕâÖÖ·½·¨£©¡£Èç´ËÑ»·£¬Ö±ÖÁ²Âµ½±íÃûΪֹ¡£
±íÃû²Â³öÀ´ºó£¬½«Count(*)Ìæ»»³ÉCount(×Ö¶ÎÃû)£¬ÓÃͬÑùµÄÔÀí²Â½â×Ö¶ÎÃû¡£
ÓÐÈË»á˵£ºÕâÀïÓÐһЩżȻµÄ³É·Ö£¬Èç¹û±íÃûÆðµÃºÜ¸´ÔÓû¹æÂɵģ¬ÄǸù±¾¾ÍûµÃÍæÏÂÈ¥ÁË¡£ËµµÃºÜ¶Ô£¬ÕâÊÀ½ç¸ù±¾¾Í²»´æÔÚ100%³É¹¦µÄºÚ¿Í¼¼Êõ£¬²ÔÓ¬²»¶£ÎÞ·ìµÄµ°£¬ÎÞÂ۶༼Êõ¶à¸ßÉîµÄºÚ¿Í£¬¶¼ÊÇÒòΪ±ðÈ˵ijÌÐòдµÃ²»ÑÏÃÜ»òʹÓÃÕß±£ÃÜÒâʶ²»¹»£¬²ÅÓеÃÏÂÊÖ¡£
ÓеãÅÜÌâÁË£¬»°Ëµ»ØÀ´£¬¶ÔÓÚSQLServerµÄ¿â£¬»¹ÊÇÓа취ÈóÌÐò¸æËßÎÒÃDZíÃû¼°×Ö¶ÎÃûµÄ£¬ÎÒÃÇÔڸ߼¶ÆªÖлá×ö½éÉÜ¡£
×îºó£¬ÔÚ±íÃûºÍÁÐÃû²Â½â³É¹¦ºó£¬ÔÙʹÓÃSQLÓï¾ä£¬µÃ³ö×ֶεÄÖµ£¬ÏÂÃæ½éÉÜÒ»ÖÖ×î³£Óõķ½·¨£AsciiÖð×Ö½âÂë·¨£¬ËäÈ»ÕâÖÖ·½·¨ËٶȺÜÂý£¬µ«¿Ï¶¨ÊÇ¿ÉÐеķ½·¨¡£
ÎÒÃǾٸöÀý×Ó£¬ÒÑÖª±íAdminÖдæÔÚusername×ֶΣ¬Ê×ÏÈ£¬ÎÒÃÇÈ¡µÚÒ»Ìõ¼Ç¼£¬²âÊÔ³¤¶È£º
http://www.19cn.com/showdetail.asp?id=49 and (select top 1
len(username) from Admin)>0
ÏÈ˵Ã÷ÔÀí£ºÈç¹ûtop
1µÄusername³¤¶È´óÓÚ0£
Ïà¹ØÎĵµ£º
×öÏîÄ¿ÀïÃæµÄÊý¾Ý¿âÉè¼ÆÁËÁ½¸öÀàÐÍ·ÅÒ»¸ö×Ö¶ÎÀïÃæ,ÎÒÓÖҪͨ¹ý·Ö¿ªµÄÀàÐÍÀ´½øÐвéѯ,Í´¿à°¡,
Á½ÖÖ·½·¨;
1,¶ÁÈ¡µ½»º´æÖÐ×Ô¶¨Òådatatable, ´úÂë¾Í²»ÌùÁË.
²»ÐÀÉÍÕâÖÖ×ö·¨,ÒòΪÎÒÒѾ°ÑÒ³ÃæÉϺܶණÎ÷дÁË,¶¼ÊÇÓеÄSqlÓï¾ä,ÕâÑù¸Äһ϶¼Òª¸ÄÁË.
2.Ö±½ÓÔÚSqlÀïÃ潨ÊÓͼ,
lÓÃSUBSTRING(dbo.K_ProductDtl.Caizhi, 0, CH ......
×¼±¸¹¤×÷£ºÊý¾ÝÇåÏ´¡£¼ì²éÊý¾ÝÀàÐͺͱíÖеÄ×Ö¶ÎÀàÐÍÊÇ·ñÆ¥Å䣻¼ì²é¿ÕÖµÔ¼Êø£»È¥Î޹ؿոñµÈ¡£ÕâЩ¼ì²é¹¤×÷¿ÉÒÔͨ¹ýExcelµÄÊý¾Ýɸѡ¹¦ÄÜ£¬¿´Ò»ÏÂÿ¸ö×Ö¶ÎËùÓеÄÖµ£¬ÔÙÑ¡Öв»ºÏ¹æ·¶µÄ½øÐÐÐ޸ġ£
²½Ö裺
1£©µÇ¼pl/sql developer£¬µÇ¼ʱѡÔñ´ýµ¼Èë±íËùÔÚÊý¾Ý¿â£¬ÔÚ²éѯ´°¿ÚÀïÊäÈësele ......
SQL Server 2005 ·þÎñÆ÷½ÇÉ«ºÍÊý¾Ý¿â½ÇÉ«ÃûÈ«½â
/*·þÎñÆ÷½ÇÉ«*/
sysadmin
--ÔÚ SQL Server ÖнøÐÐÈκλ¡£¸Ã½ÇÉ«µÄȨÏÞ¿çÔ½ËùÓÐÆäËü¹Ì¶¨·þÎñÆ÷½ÇÉ«¡£
serveradmin
--ÅäÖ÷þÎñÆ÷·¶Î§µÄÉèÖá£
setupadmin
--Ìí¼ÓºÍɾ³ýÁ´½Ó·þÎñÆ÷£¬²¢Ö´ÐÐijЩϵͳ´æ´¢¹ý³Ì£¨Èç sp_serveroption£©¡£
securityadmin
--¹ÜÀí·þÎñÆ÷ ......
¼¸µÀ¾µäµÄSQL±ÊÊÔÌâÄ¿£¨Óд𰸣©
£¨1£©±íÃû£º¹ºÎïÐÅÏ¢
¹ºÎïÈË ÉÌÆ·Ãû³Æ ÊýÁ¿
A ¼× 2
B ÒÒ &n ......
1¡¢²éÕÒÔ±¹¤µÄ±àºÅ¡¢ÐÕÃû¡¢²¿ÃźͳöÉúÈÕÆÚ£¬Èç¹û³öÉúÈÕÆÚΪ¿ÕÖµ£¬ÏÔʾÈÕÆÚ²»Ïê,²¢°´²¿ÃÅÅÅÐòÊä³ö,ÈÕÆÚ¸ñʽΪyyyy-mm-dd¡£
select
emp_no,emp_name,dept,isnull(convert(char(10),birthday,120),'ÈÕÆÚ²»Ïê') birthday
from employee
order by dept
¡¡¡¡
2¡¢²éÕÒÓëÓ÷×ÔÇ¿ÔÚͬһ¸öµ¥Î»µÄÔ±¹¤ÐÕÃû¡¢ÐÔ±ð¡ ......