sql server 2000 +aspÍøÕ¾7¸öСʱºó³öÎÊÌâ
×Ô´ÓÖ±½ÓÔÚÒ»¸ö±íÀï¼ÓÁ˸ö×ֶΣ¨nvarchar ÆäËûĬÈÏ£¬²»²åÈë×Ô¼ºÄ¬ÈÏΪ <null>£©ºó,ÖØÆôÍøÕ¾+sql server 2000 6-8¸öСʱºó³öÏÖÎÊÌâ£ºÍøÕ¾Ð´Êý¾Ý¿âʱ½Å±¾³¬Ê±
Active Server Pages ´íÎó 'ASP 0113'
½Å±¾³¬Ê±
µ¼ÖÂÕû¸öÍøÕ¾cpuÕ¼Óôï50%£¬±ØÐëÖØÆôÍøÕ¾¡¢Êý¾Ý¿â²ÅÄÜÕý³£,ÄѵÀÊǶÔÊý¾Ý¿âÓÐÎó²Ù×÷£¿¼ÇµÃÖ»ÓÃÖ´Ðйý²éѯÓï¾ä°¡
ÊDz»ÊÇASP´úÂëÓÐÎÊÌâ,°ÑÖ´ÐеĴúÂëÌù³öÀ´¿´¿´
Êý¾Ý¿âÁ¬½ÓºÍ¼Ç¼¼¯ÓÐûÓм°Ê±¹Ø±Õ²¢ÉèΪNothing£¿
³ÌÐòûÓиĹý£¬Ö»¸ÄÁËÊý¾Ý¿â£¬ÒòΪ¸ÄµÄÖ»ÊDzâÊÔµÄÍøÕ¾£¬¸ÄÍêµÄ»¹Ã»ÉÏ´«£¬Ö»ÓÃͬһ¸öÊý¾Ý¿â²âÊÔ
Ó¦¸Ã²»ÊÇʲô´óÎÊÌâ
´úÂëÎÊÌ⣿»¹ÊÇÉÏ´«×é¼þµÄÎÊÌ⣿ºÃºÃ²é²é°É¡£
Èç¹ûÄãµÄÊý¾Ý¿âºÜ¾Þ´ó¡£°´ÕÕaspµÄÀ¬»ø´¦ÀíÄÜÁ¦£¬²»³öʲŹ֡£
ÔÒò£¬ÄãµÄ×ֶα»¾³£·ÃÎÊ£¬È´Ã»ÓÐ×öË÷Òý
¡¡¡¡ºÍÄã¼ÓµÄÊý¾Ý¿â×Ö¶Îûʲô¹ØÏµ£¬Äã¿ÉÒÔ½øÈësql server¹ÜÀí£¬²é¿´Ò»Ï»µÄÓû§£¬¿´Ò»ÏÂÐÔÄÜ£¬ÕâÑù¾ÍÖªµÀÊý¾Ý¿âÐÔÄܵÄÎÊÌâ¡£
¡¡¡¡¿´¿´ÄãµÄÍøÕ¾ÊDz»ÊDZ»²åÈëÁËľÂí³ÌÐò£¡
cpuÕ¼Óôï50%
ÊDz»ÊÇÓеط½ÏÝÈëËÀÑ»·µ±ÖÐŶ£¡
´úÂëÓÐÎÊÌâ
´úÂë.
Ïà¹ØÎÊ´ð£º
±¾ÈËc#ÐÂÊÖ ¿ÉÊÇÒªÇóÒªÓÃc# £¬sql2000¿ª·¢c/sµÄ¹¤×÷Á÷£¬Ò»Í·ÎíË®£¬Çë´ó¼Ò°ïæ°ï棬¸øµã˼·£¬ËµµÄÔ¼¾ßÌåÔ½ºÃ£¬ÎÒÒ²ºÃÍùÄǸö·½ÃæÈ¥Ñ§Ï°
http://www.hxzi.com/view/61402.html
B/S°æµÄ£¬»ù±¾Ë¼ÏëÓ¦¸Ã²î²»¶àµÄ¡£¡£ ......
ÎÒÏëÓÃaspд¸öÒ³ÃæÒÔǰûÓнӴ¥¹ý£¬ÎÒ¿´ÍøÉÏ˵aspµÄÔËÐл·¾³Ö»ÄÜÊÇwindows£¬»¹±ØÐëҪװIIS¡£
Çë½Ì¸÷λ¸ßÊÖ£¬asp»¹ÓÐÆäËûµÄÔËÐл·¾³Âð?
²î²»¶à¾ÍÕâЩÁË£¬¾ÍÊÇIISÒ»¶¨Òª×°ºÃ
»¹ÓÐÒªÊÇÓÃVS2005µÄ»°ºÃÏñ¿ÉÒÔÖ±½ÓÔ ......
<%
Sql="select top 8 * from NewsData where d_classid in (select classid from NewsClass where ParentID=16)"
Rs.Open Sql, conn, 1,1
Do Until Rs.Eof
......
ÓÐËÄܸø½²½²£¬Ôõô×öÂð£¿
ллÀ²£¡
¸ÊÌØÍ¼ ÊÇɶ£¿
½âÌâ˼·.¿´Ò»Ï½ø¶ÈÌõµÄÏÔʾ..
ÆäʵÄã¾ÍŪһ¶Ñtable ÿ¸ötableµÄ¿í¶È²»Í¬.µ×É«²»Í¬¼´¿É
µ±È»ÓÃdiv¿ØÖÆÎ»ÖøüºÃ
ÄãŪ100¸ötable¸ù¾Ý½ø¶ÈÆäÖÐǰ20¸ö·Ö¸øµ ......
Replaceº¯ÊýÈçºÎĬÈÏÊÇ´Ó×ó¶ËÌæ»»£¬ÈçºÎʹÆä´ÓÓұ߿ªÊ¼Ìæ»»£¬¼´Ìæ»»Ò»¸ö×Ö·û´®µÄ×îºóÒ»¸ö×Ö·û£¬Ìæ»»´ÎÊýΪ1´Î£¬Ð»Ð»
ÒýÓÃ
VBScript code <%
Response.Write ReplaceRev("abcdefXXXghi"," ......