SQLÖд洢¹ý³ÌÖÐSQLÓï¾äµÄµ¥ÒýºÅºÍË«ÒýºÅÎÊÌâ
Ö£ÖØÉùÃ÷һϣ¬ÕâÆªÈÕÖ¾ÊÇÎÒCopyµÄ£¬²»ÊÇ×Ô¼ºÐ´µÄ£¬ÎÒ»¹Ã»ÄÇôǿ£¡(×Ðϸ¿´Ò»Ï£¬ÓÐÓá£)
¹ØÓÚSQLÓï¾äÖеÄË«ÒýºÅ¡¢µ¥ÒýºÅ£º
£¨1£©ÏÈÀ´¿´Ò»¸ö×î¼òµ¥µÄSQLÓï¾ä
Insert Into users(username) values("СÍõ")
´ó¼ÒÀ´¿´Ò»Ï£¬ÕâÊÇÒ»¸ö±ê×¼µÄSQLÓï¾ä£¬ÒòΪusernameÊÇÎı¾ÐÍ×ֶΣ¬ËùÒÔ×Ö¶ÎÖµÁ½±ßÒª¼ÓË«ÒýºÅ£¬±íʾСÍõÊÇÒ»¸ö×Ö·û´®¡£
£¨2£©¿ÉÊÇÔÚASPÖУ¬ÎÒÃÇͨ³£ÕâÑùд
strSql="Insert Into users(username) values('СÍõ')"
´Ëʱ£¬Ç°ºóµÄË«ÒýºÅ±íʾÖмäÊÇÒ»¸ö×Ö·û´®¡£¶øÐ¡ÍõÁ½±ßµÄµ¥ÒýºÅÊÇÒòΪ·¢ÉúÁËÒýºÅǶÌ×£¬ËùÒÔÄÚ²ãÒýºÅ¸ÃΪÁ˵¥ÒýºÅ¡£
£¨3£©Êµ¼Ê²åÈëʱ£¬ÒòΪСÍõͨ³£ÊÇ´Ó±íµ¥ÖлñÈ¡µÄ±äÁ¿£¬²»¹ýÒòΪ±äÁ¿²»ÄÜÖ±½ÓдÈë×Ö·û´®£¬±ØÐëͨ¹ýÁ¬½Ó·ûºÍ×Ö·û´®Á¬½ÓÔÚÒ»Æð£¬ËùÒÔҪд³ÉÈçÏÂÐÎʽ£º
myusername=Request.Form("username")
……
strSql="Insert Into users(username) values('" & myusername & "')"
ºÜ¶àÈË´Ëʱ¾ÍºýÍ¿ÁË£¬ÎªÊ²Ã´ÆäÖÐÓÖÓе¥ÒýºÅ£¬ÓÖÓÐË«ÒýºÅ°¡¡£¼òµ¥µÄ¿´ÉÏÃæµÄʽ×Ó£¬ÆäʵÊÇÓÉÈçÏÂÈý²¿·Ö×é³ÉµÄ£º
×Ö·û´®³£Êý£º"Insert Into users(username) values('"
×Ö·û´®±äÁ¿£ºmyusername
×Ö·û´®³£Êý£º"')"
Ö±½ÓÀí½âÉÏÃæµÄʽ×Ó¿ÉÄܱȽÏÀ§ÄÑ£¬ÏÖÔÚÎÒÃDZäÁ¿myusernameµÄÖµ´úÈë¾ÍÄÜ¿´Çå³þÁË¡£¼ÙÈçmyusername="СÍõ"£¬´úÈ룺
strSql="Insert Into users(username) values('" & "СÍõ" & "')"
È»ºóÒÀ´ÎÖ´ÐÐÆäÖеÄÁ¬½ÓÔËËã·û£¬½á¹ûΪ£º
strSql="Insert Into users(username) values('СÍõ')"
Õâ¾ÍÊÇ£¨2£©ÖÐÌá
Ïà¹ØÎĵµ£º
SQL SERVER 2005 ¼ò½é
Ò»Ö±ÒÔÀ´£¬T-SQL¶¼ÊÇÈÝÒ×ÉÏÊֵĽṹ»¯²éѯÓïÑÔ£¬Ëæ×ÅSQL ServerµÄ°æ±¾Ñݽø£¬³ýÁËÄÚ²¿¹¦ÄÜÔö¼Ó£¬
T-SQLÒ²´ó·ùÀ©ÔöÁËеIJéѯָÁî¡£ÀýÈ磺XQuery¡¢È¡µÃÅÅÃû˳ÐòµÄº¯Êý¡¢¼¯ºÏÔËËã´îÅäOVERÔËËã·û¡¢TOPÔËËã·û¿ÉÒÔ´îÅä±äÁ¿»ò×Ó²éѯ£¬ÒÔ¼°Í ......
SQL×¢Èëʽ¹¥»÷ÊÇÀûÓÃÊÇÖ¸ÀûÓÃÉè¼ÆÉϵÄ©¶´£¬ÔÚÄ¿±ê·þÎñÆ÷ÉÏÔËÐÐSqlÃüÁîÒÔ¼°½øÐÐÆäËû·½Ê½µÄ¹¥»÷¶¯Ì¬Éú³ÉSqlÃüÁîʱûÓжÔÓû§ÊäÈëµÄÊý¾Ý½øÐÐÑéÖ¤ÊÇSql×¢Èë¹¥»÷µÃ³ÑµÄÖ÷ÒªÔÒò¡£
±ÈÈ磺
Èç¹ûÄãµÄ²éѯÓï¾äÊÇselect * from admin where username="&user&" and password="&pwd&""
ÄÇô£¬Èç¹ûÎÒµÄÓû§ÃûÊ ......
±íÖÐÖ÷¼ü±ØÐëΪ±êʶÁУ¬[ID] int IDENTITY (1,1)
1.·ÖÒ³·½°¸Ò»£º(ÀûÓÃNot InºÍSELECT TOP·ÖÒ³)
Óï¾äÐÎʽ£º
SELECT TOP Ò³¼Ç¼ÊýÁ¿ *
from ±íÃû
WHERE (ID NOT IN
(SELECT TOP (ÿҳÐÐÊý*(Ò³Êý-1)) ID
from ±íÃû
ORDER BY ID))
ORDER BY ID
//×Ô¼º»¹¿ÉÒÔ¼ÓÉÏһЩ²éѯÌõ¼þ
Àý:
sele ......
< type="text/javascript">
< type="text/javascript">
Èç×ªÔØ£¬Çë×¢Ã÷³ö´¦£ºhttp://blog.csdn.net/robinson_0612/archive/2009/11/07/4783702.aspx
Ëæ×ŵ±½ñÊý¾Ý¿âµÄÈÝÁ¿Ô½À´Ô½¿ìµÄ³¯×ÅÔÚ´óÐÍÊý¾Ý¿â»ò³¬´óÐÍÊý¾Ý¿âµÄ·¢Õ¹£¬¶ÔÓÚÊý¾Ý¿âÖеĴóÐͱíÒÔ¼°¾ßÓи÷ÖÖ·ÃÎÊģʽµÄ±íµÄ¿ÉÉìËõÐ ......
±à¼Ç°ÑÔ£ºÕâ¸öÎÄÕÂÎÒûÓвâÊÔ£¬µ«Ç°ÌáÌõ¼þ»¹ÊǺܶ࣬±ÈÈçÒ»¶¨ÒªÓбðµÄ³ÌÐò´æÔÚ£¬¶øÇÒÒ²ÒªÓÃͬһ¸öSQLSERVER¿â£¬»¹µÃ¼ÙÉèÓÐ×¢Èë©¶´¡£Ëµµ½µ×ºÍ¶¯ÍøÃ»ÓÐʲô¹ØÏµ£¬µ«ÒòΪ¶¯ÍøÂÛ̳µÄ¿ª·ÅÐÔ£¬ÈÃÈËÊìϤÁËÆäÊý¾Ý¿â½á¹¹£¬ºÍ³ÌÐòÔË×÷·½·¨¡£ÔÚÒ»²½²½µÄ¹¥»÷ÖÐÈ¡µÃ¹ÜÀíȨÏÞ£¬ÔÙÒ»²½²½µÄÌáÉýȨÏÞ£¬Èç¹ûÕýºÃÊý¾Ý¿âÓõÄÊÇSAÕʺţ¬¾Í¸üÊÇ ......