ÃÅÍ⺺ÇóÖú...¹ØÓÚºǫ́+SQL+ASP
....½Óµ½Ò»¸öС³ÌÐò..¹¤×÷ÔÀ´´ó¸ÅÊÇÕâÑùµÄ...ǰ̨ÊÇWEB·þÎñÆ÷.¼Ü¹¹¾ÍÊÇASP+SQL..ǰ̨ÓÉASPÏòSQLÌí¼Ó·þÎñÀà±ð(±íµ¥).È»ºóÓÖºǫ́³ÌÐò¶ÁÈ¡±íµ¥..Ҫʵʱ¶ÁÈ¡..È»ºóÏÔʾÔÚ·þÎñÆ÷ÉÏÃæ..´ÓÀíÂÛÉÏÃæÄÜÐÐͨ²»?Èç¹û¿ÉÒÔ..ºǫ́¿ÉÒÔÓÃVB¿ª·¢Ã´??ÎÒ¸öÈ˶ÔÓÚVBÉÔ΢ÊìϤһЩ
¿ÉÒÔʵÏֵģ¡ Ŷ ¿ÉÒÔÓÃVBʵÏÖ,C#Ò²¿ÉÒÔ,È¥ASP°æÈ¥ÎÊÏ ½¨ÒéÓÃASP ¸Ð¾õ±ÈVBÎȶ¨ ¹¦ÄܱÈVB¸ü¼ÓÈÝÒ×ʵÏÖ ÎÊÒ»ÏÂÂ¥ÉÏÀÏÐÖ.ASPÒ²¿ÉÒÔдºǫ́³ÌÐòô??ºǫ́³ÌÐòÒªÇó²éѯ.´òÓ¡.ÒÔ¼°ÏµÍ³Ìáʾ֮ÀàµÄ¹¦ÄÜÒýÓà ÎÊÒ»ÏÂÂ¥ÉÏÀÏÐÖ.ASPÒ²¿ÉÒÔдºǫ́³ÌÐòô??ºǫ́³ÌÐòÒªÇó²éѯ.´òÓ¡.ÒÔ¼°ÏµÍ³Ìáʾ֮ÀàµÄ¹¦ÄÜ ASPÒ²¿ÉÒÔдµÄѽ,Ó¦¸ÃÒªÓÃWINFORM
Ïà¹ØÎÊ´ð£º
type Exception report message description The server encountered an internal error () that prevented it from fulfilling this request. exception org.apache.jas ......
ÎÒÓÐÒ»¸ö±í£¬½á¹¹ÊÇÕâÑù¡£ ת³ö µ¥Î» תÈ뵥λ ±ÊÊý ½ð¶î date(Ö÷) outid(Ö÷) inid(Ö÷) num amt 2009 1 2 1 500 Ϊ 1 µ¥Î» ÔÚ2009Ä ......
ÕâÀïÏëÁ˽âÏ£¬¹ØÓÚSQL ServerÖзÖÒ³ºÍOracleÖзÖÒ³£» ƽ³£Ð´Ó¦ÓóÌÐòµÄʱºò£¬±ÈÈçÓõÄÓïÑÔÊÇJava£¬ÓиöÁбíÒ³Ãæ£¬ÐèÒª¶ÔÊý¾Ý·ÖÒ³ÏÔʾ£» ÕâÀïÒª·ÖÒ³ÄѵÀ²»ÐèÒª½èÖúJava£¬¶øÖ±½ÓsqlÄÜÖªµÀ·ÖÒ³Âð£¬ÆðÂëÒ²Òª´«¸öÒ³Âë½ ......
Ôõô°ÑMDFÊý¾Ýתµ½MySQL£¿ ÖÁÉٵø½¼Óµ½sqlserverÉÏ ¾ßÌåÔõôŪ°¡ ÎҵıÏÒµÉè¼ÆµÄÊý¾Ý¿âÊÇ´ÓÍøÉÏdownÏÂÀ´µÄ£¿£¿ Ä㻹²»ÈçÖ±½ÓÓÃsqlserverÄØ º¯Êý¡¢´æ´¢¹ý³Ì¶¼µÃ¸ÄÁË¡£ sqlserverûÔõôÓùý¡£Ò²Ã»Óа²× ......
select o_customer,o_price from orders having o_price >=avg(o_price) select o_customer,o_price from orders where o_price >=(select avg(o_price) from orders) ÎҸоõûÓÐÇø±ð°¡£¬ÔõôÔÚmysql»áÓÐ ......