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

asp wap sqlÓï¾äÖлñÈ¡µÄºº×Ö²»ºÃÊ - Web ¿ª·¢ / ASP

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Õ¾Àï ±¾ÉíÓÐÊý¾Ý µ«ÊÇ»¹ÊÇËÑË÷²»µ½
ÔÚÊý¾Ý¿âÀïÃæÖ±½ÓÔËÐÐ
£ºselect * from guide where city_name='±±¾©' order by pai descÊÇ·ñÓнá¹û£¿
±±¾©ÊÇÄã´«µÝµÄ²ÎÊý£¿»¹ÊÇÖ±½Ó¾ÍÄÇÑùдµÄ£¿£¿

ÒýÓÃ

ÔÚÊý¾Ý¿âÀïÃæÖ±½ÓÔËÐÐ
£ºselect * from guide where city_name='±±¾©' order by pai descÊÇ·ñÓнá¹û£¿
±±¾©ÊÇÄã´«µÝµÄ²ÎÊý£¿»¹ÊÇÖ±½Ó¾ÍÄÇÑùдµÄ£¿£¿


ÎÒÕâ¿ìÊÇ»ñÈ¡µÄÖµ ×Ö¶ÎÀï¿Ï¶¨Óб±¾© ¶øÇҺü¸Ìõ µ«¾ÍÊDz»ÏÔʾ³öÀ´ µ«ÊÇÈç¹ûÎÒ°ÑÓï¾ä¸Ä³É
select * from guide where id>2500 order by pai desc
¾ÍÄÜÑ­»·do while Óï¾äÁË

ÔÚÊý¾Ý¿âÀïÃæÖ±½ÓÔËÐÐ
select * from guide where city_name='±±¾©' order by pai desc

ÊÇ·ñÓнá¹û£¿
Êý¾Ý¿âÀïÃæÃ»ÓÐÎÊÌâ ¾Í ²»»áÓÐʲôÎÊÌâ




Ïà¹ØÎÊ´ð£º

csvÎļþת»»³Ésqlµ¼Èëµ½Êý¾Ý¿â£¬Ã»ÓÐÊý¾ÝΪºÎ£¿

Ö´ÐеÄ˳Ðò£º
1£©Îļþä¯ÀÀ¿ò£¨Ñ¡ÔñÎļþʹÓã©
Ñ¡ÔñºÃÎļþºó
µã»÷Ò»¸öµ¼Èë°´Å¥µÄʱºò £¬°ÑÉÏÃæÉÏ´«¿òÀïµÄcsvÎļþÒÔÒ»¸öIDΪÎļþÃû£¬ÉÏ´«µ½**/**Îļþ¼ÐÏÂ
2£©¶ÁÈ¡Õâ¸öÎļþ¼ÐϵÄcsvµÄÎļþ£¬×ª»»³Ésql
3 ......

sqlССµÄÒÉÎÊ - .NET¼¼Êõ / C#

¿ÉÄÜÒòΪ¹¤×÷µÄÔ­Òò ½Ó´¥Êý¾Ý¿âÕâ¿é±È½ÏÉÙ£¬Ö®Ç°¶¼ÊÇ×ö³ÌÐòÕâ¿é£¬Êý¾Ý¿âÕâ¿é¶¼ÓÐרÃŵÄÈËÀ´×ö ·Ö¹¤¶¼ºÜÃ÷ϸ ËùÒÔ¶ÔÊý¾Ý¿âÕâÒ»¿éÍêÈ«²»Á˽⡣ǰ¶Îʱ¼ä È¥ÃæÊÔÁ˼¸¼Ò¹«Ë¾ ¼¸ºõ¶¼ÊÇÔÚÊý¾Ý¿âÕâ¿é¹ÒµôµÄ Á¬¸ö¼òµ¥µÄSQ ......

sql ÎÊÌâ - MS-SQL Server / »ù´¡Àà

ÐèÇóÈçÏ£º
ѧԺ academy£¨aid,aname£©
°à¼¶ class£¨cid,cname,aid£©
ѧÉú stu(sid,sname,aid,cid)
סËÞÇø region(rid,rname)
ËÞÉáÂ¥ build(bid,rid,bnote) bnoteÊÇ¡®ÄС¯/¡®Å®¡¯
ËÞÉá dorm(did,rid,bid£¬bedn ......

asp.netÈçºÎÌá¸ß·ÃÎÊËÙ¶È - .NET¼¼Êõ / ASP.NET

ÎÒ×î½ü×öÁËÒ»¸öÍøÕ¾ÊǹØÓÚ²úƷչʾµÄ ~ Õû¸öÍøÕ¾Í¼Æ¬¶¼Õ¼ÓÃÁËÒ»´ó°ë  
ÕâÑùµÄ»°·ÃÎÊËٶȾͷdz£Âý ÓÐʲô°ì·¨¿ÉÒÔ½â¾öÂð£¿
Âé·³´ó¼Ò¶à¶à¸øµãÒâ¼û £¡ ÓÐʲô¾¡¹Ü˵ 
3Q´ó¼Ò
htmlÒ³Ãæ.

Õâ¸ö,¼ÈÈ»Ö÷Ò ......

ASPÒ³ÃæÎÞ·¨´ò¿ªÇóÖú£¡ - MS-SQL Server / »ù´¡Àà

¸÷λºÃ£¬ÎÒ¸Õ°ÑÒ»¸öASPÍøÕ¾ÉèÖúÃÁË£¬Ò²ÄÜÕý³£·ÃÎÊ¡£µ«ÊÇÔÚÎÒ±¾»úÉϲ»ÄÜ´ò¿ªadmin\login.asp,ËùÒÔÎÞ·¨ÊµÏÖºǫ́¹ÜÀí¡££¨´íÎóÌáʾÎÞ·¨ÕÒµ½ÍøÒ³£¬´úÂë404£¬ÎҵIJÙ×÷ϵͳÊÇwin2000 server)
µ«ÊÇÆæ¹ÖµÄÊÇÔÚ¾ÖÓòÍøµÄÆäËû» ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ