Çë½ÌÒ»¸öSQLÓ¦ÓÃÎÊÌâ
ÓÐʱºòÔÚÊý¾ÝÖвéѯÊý¾ÝµÄʱºò¿¼ÂÇÐÔÄÜÎÊÌ⣬»á½«¸´ÔÓÓï¾ä²ð·Ö»ò½èÓÃÁÙʱ±íÀ´¶à´Î²éѯ×îÖյõ½ÏëÒªµÄÊý¾Ý£¬ÏÖÔÚ½«ÕâЩ²éѯÄÚÈÝ×ö³É±¨±í£¬ÐèҪд¸öÓï¾äÒ»ÆøºÇ³É¡£ ÎÒÏëÎʵÄSQLÊÇ·ñ¿ÉÒÔÔÚ²éѯÓï¾äÒ»½áÊøºó£¬ÔÙ×Ô¶¯ÔËÐвéѯÓï¾ä¶þ£¬Í¬Ê±µÚ¶þ¸ö²éѯÓï¾äÖÐÒªµ÷ÓòéѯÓï¾äÒ»µÄÊý¾Ý£¬ÕâÑùÓÃSQLÖÐʲôº¯Êý»òÓï¾ä¿ÉÒÔʵÏÖÄØ£¿
Åú´¦Àí ½Å±¾£¿ Ôõôд°¡£¿Äܸø¸öʵ¼ÊÀý×ÓÂ𣿠ÒýÓà ½Å±¾£¿ up
Ïà¹ØÎÊ´ð£º
¸÷λ´óÏÀ£ºÇëÎÊÔõÑùÔÚASP³ÌÐòÖе÷ÓÃSQL´æ´¢¹ý³Ì£¿Ð»Ð»£¬Çë¸ø¸öÀý×Ó£¡ http://hi.baidu.com/lz0830/blog/item/e847e5e9077fde39b80e2db9.html 1 ÕâÒ²ÊÇ×î¼òµ¥µÄ·½·¨,Á½¸öÊäÈë²ÎÊý£¬ÎÞ·µ»ØÖµ£º set con ......
×Ô´ÓÖ±½ÓÔÚÒ»¸ö±íÀï¼ÓÁ˸ö×ֶΣ¨nvarchar ÆäËûĬÈÏ£¬²»²åÈë×Ô¼ºÄ¬ÈÏΪ <null>£©ºó,ÖØÆôÍøÕ¾+sql server 2000 6-8¸öСʱºó³öÏÖÎÊÌ⣺ÍøվдÊý¾Ý¿âʱ½Å±¾³¬Ê± Active Server Pages ´íÎó 'ASP 0113 ......
....½Óµ½Ò»¸öС³ÌÐò..¹¤×÷ÔÀ´´ó¸ÅÊÇÕâÑùµÄ...ǰ̨ÊÇWEB·þÎñÆ÷.¼Ü¹¹¾ÍÊÇASP+SQL..ǰ̨ÓÉASPÏòSQLÌí¼Ó·þÎñÀà±ð(±íµ¥).È»ºóÓÖºǫ́³ÌÐò¶ÁÈ¡±íµ¥..Ҫʵʱ¶ÁÈ¡..È»ºóÏÔʾÔÚ·þÎñÆ÷ÉÏÃæ..´ÓÀíÂÛÉÏÃæÄÜÐÐͨ²»?Èç¹û¿ÉÒÔ..ºǫ́ ......
ÈçÌâ:Ç°¼¸Ìì·þÎñÆ÷»¹ÊÇºÃºÃµÄ ½ñÌìÍøÒ³´ò²»¿ªÍ»È»³öÏÖ´íÎó,Ò»²éÊÇÁ´½Ó²»ÉÏÊý¾Ý¿âÁË? (²éѯ·ÖÎöÆ÷ºÍÆóÒµ¹ÜÀíÆ÷¶¼¿ÉÒÔÕý³£ÏÔʾ) [SqlException (0x80131904): Óû§ 'sa' µÇ¼ʧ°Ü¡£]
......
´ó¼ÒºÃ£¬ÇëÎÊÔÚ±íMÖÐÓÐ×ֶΣºa b c d e ÎÒÏë²é³öÆäÖÐÂú×ãÏÂÃæÈÎÒâÒ»ÏîµÄÊý¾Ý£¬1.×Ö¶Îa µÄÖµ²»ÊÇ ¡®Êé»ò±Ê»ò±¾¡¯ÖÐÈÎÒ»£¬2.aΪÊéµÄʱºò×Ö¶Îb,cÊÇ¿Õ;3.µ±aֵΪ±ÊµÄʱºòdÊÇ¿Õ;4.µ±aΪ±¾µÄʱºòb,d,e¶¼ÊÇ¿Õ;5.È ......