sql Ö÷Íâ¼ü - MS-SQL Server / »ù´¡Àà
ÈçºÎij±íµÄ×ֶ௒äËü±íÒýÓã¬Ö÷Íâ¼ü¹ØÏµ£¬ÄѵÀÒª±éÀúËùÓÐÓë¸Ã±íµÄ¸Ã×ֶν¨ÓÐÖ÷Íâ¼ü¹ØÏµµÄ±íÂð£¿
ÈçºÎij±íµÄ×ֶ௒äËü±íÒýÓã¬...
ËÆºõ²¢Î´±í´ïÇå³þ,Óï·¨Ò²²»Í¨.
²»Çå³þÄãÏë¶Ô¸Ã×Ö¶Î×öʲô²Ù×÷£¿
Òª×öʲô
²»ºÃÒâ˼£¬Ã»×¢Ò⣬
Ó¦¸ÃÊÇ£ºÈçºÎÅжÏij±íµÄ×ֶ௒äËü±íÒýÓã¬Ö÷Íâ¼ü¹ØÏµ£¬ÄѵÀÒª±éÀúËùÓÐÓë¸Ã±íµÄ¸Ã×ֶν¨ÓÐÖ÷Íâ¼ü¹ØÏµµÄ±íÂð£¿
Èç¹û¸Ã±íµÄÕâ¸ö×ֶ௒äËû±íÒýÓõϰ£¬¾Í²»ÔÊÐí¶Ô¸Ã±íµÄÆäËü×ֶνøÐÐÐ޸IJÙ×÷
shuohua dou shuo ˵»°¶¼Ëµ²»Çå³þ °³FUÁË ÓÐ
Èç¹û¸Ã±íµÄÕâ¸ö×ֶ௒äËû±íÒýÓõϰ£¬¾Í²»ÔÊÐí¶Ô¸Ã±íµÄÆäËü×ֶνøÐÐÐ޸IJÙ×÷
»¹ÓÐÕâÑùµÄÐèÇóѽ£¿
¾ßÌåÔõôÅжϱíµÄij¸ö×ֶ௒äËü±íµÄ×Ö¶ÎÒýÓÃÄØ£¿
ÍøÉϲé²é¿´£¬Ó¦¸ÃÓÐÏàÓ¦µÄ·½·¨
Èç¹û¸Ã±íµÄÕâ¸ö×ֶ௒äËû±íÒýÓõϰ£¬¾Í²»ÔÊÐí¶Ô¸Ã±íµÄÆäËü×ֶνøÐÐÐ޸IJÙ×÷
½ö¹©²Î¿¼
Â¥Ö÷Äúû˵ÄãÏëÒª×öʲô
Ïà¹ØÎÊ´ð£º
Ö´ÐеÄ˳Ðò£º
1£©Îļþä¯ÀÀ¿ò£¨Ñ¡ÔñÎļþʹÓã©
Ñ¡ÔñºÃÎļþºó
µã»÷Ò»¸öµ¼Èë°´Å¥µÄʱºò £¬°ÑÉÏÃæÉÏ´«¿òÀïµÄcsvÎļþÒÔÒ»¸öIDΪÎļþÃû£¬ÉÏ´«µ½**/**Îļþ¼ÐÏÂ
2£©¶ÁÈ¡Õâ¸öÎļþ¼ÐϵÄcsvµÄÎļþ£¬×ª»»³Ésql
3 ......
ÏÖÔÚÓÐÁ½ÕÅ±í£ºÎÄÕÂÖ÷±íA(articleId,articleTitle)£¬ÎÄÕÂÆÀÂÛ±íB(commentId,articleId,commentTitle)
ÏÖÔÚÎÒÏëʵÏÖÕâÑùµÄ¹¦ÄÜ£ºÁгöÎÄÕÂÁÐ±í£¬ÆäÖÐÿƪÎÄÕ±êÌâÏÂÃæÁгö´ËÎÄÕµÄǰ2¸öÎÄÕÂÆÀÂÛ£¬ÇëÎÊsqlÓï¾äÔõôд°¡ ......
ÏÖÔÚÓÐÒ»¸ö²¿Ãűídept£¨²¿ÃÅÃû³Æ£¬²¿Ãźš£¡££©ÓÐÒ»¸öÈËÔ±±íemp£¨ÐÕÃû£¬ÈËÔ±±àºÅ£¬Ö°Î»£¬Ð½×Ê£¬²¿ÃÅ£©
emp±íÖеÄÄÚÈÝÊÇÕâÑùµÄ£º
a 1 ¹¤³Ìʦ 3000 Èí¼þ²¿
b 2 ÆÕͨԱ¹¤ 2000 Ó²¼þ²¿
c 3 ¹¤³Ìʦ 4000 Ó²¼þ²¿
d ......
¸÷λºÃ£¬ÎÒ¸Õ°ÑÒ»¸öASPÍøÕ¾ÉèÖúÃÁË£¬Ò²ÄÜÕý³£·ÃÎÊ¡£µ«ÊÇÔÚÎÒ±¾»úÉϲ»ÄÜ´ò¿ªadmin\login.asp,ËùÒÔÎÞ·¨ÊµÏÖºǫ́¹ÜÀí¡££¨´íÎóÌáʾÎÞ·¨ÕÒµ½ÍøÒ³£¬´úÂë404£¬ÎҵIJÙ×÷ϵͳÊÇwin2000 server)
µ«ÊÇÆæ¹ÖµÄÊÇÔÚ¾ÖÓòÍøµÄÆäËû» ......
SQL code:
rs.open "select * from guide where city_name='±±¾©' order by pai desc",conn,1,1
do while not rs.eof or rs.bof
¡£¡£
¡£¡£
¡£¡£
rs.movenext
loop
Õâ¸ösqlÓï¾äÔÚwapÕ¾Àï ±¾ÉíÓÐ ......