Äܲ»ÄÜ ÓÖÁ¬SQL ÓÖÁ¬ACCESS
rt
¿ÉÒÔѽ
Ò»¸ö¶ÔÏóÒ»¸öʱ¼äÖ»ÄܸÉÒ»¼þÊ£¬²»Í¬Ê±¼ä¾Í¿ÉÒԸɲ»Í¬µÄÊÂ
Â¥ÉÏÕý½â
×ÐÏ¸ÍÆÇÃÌâÄ¿£¬»¹ÊÇ2Â¥Õý½â£¡
lzÎÊÌâÓÐÆçÒå°¡
¿ÉÒÔ°¡£¬µ«ÊÇÒ»¸ö¶ÔÏó²»ÄÜͬʱÁ¬ÉÏ
configÀïÃæ°ÑÁ½¸ökey¶¼Ð´½øÈ¥¾ÍºÃÁË
ÄÜ£¬Ð´Á½¸öÁ´½Ó¾ÍºÃÁË¡£
Ïà¹ØÎÊ´ð£º
ÎÒÊý¾Ý¿âÊÇMSSQLµÄ£¬×òÌìËùÓÐµÄ±í±»×¢ÈëJS½Å±¾´úÂë,Óиö²»Ã÷°×µÄµØ·½À´ÎÊÎÊ´ó¼Ò
ÎÒ·¢ÏÖÓÐЩ±íÎÒ¸ù±¾Ã»Ê¹Óã¬Ò²Ã»ÓÐÈë¿âµÄASPÒ³ÃæºÍÓï¾ä£¬ËüÊÇÔÛ¸ö×¢ÈëµÄÄØ£¿
Ã²ËÆselectÓï¾äÊÇ¿ÉÒÔǶÌ׵İɣ¿
¿ÉÄÜÊÇwhere ......
СµÜÕý×¼±¸×Ô¼ºÌáǰѧϰÊý¾Ý¿â£¬µ«ÊÇÏÖÔÚÓиöÎÊÌ⣬²»ÖªµÀ¸ÃÑ¡Ôñʲô°æ±¾µÄSQL
ѧУÒÔºóµÄÊéºÃÏñ½²SQLÓõÄÊÇSQL 2000£¬µ«ÊÇÎÒµÄϵͳÊÇWindows 7£¬Ã²ËƲ»ÄÜ×°£¬Ò²²»Ïë»»»ØXP£¨07Äê¾Í²»ÓÃXPÀ²£©£¬ËùÒÔÔÚÏ룬ÄÜ· ......
¸÷λ´óÏÀ¾ÈÃü°¡ £¡£¡
¸Õ×°ÁËSQL2000 sp3
ÏëÓÃJSPÁ¬½ÓÊý¾Ý¿âµ«ÊdzöÏÖÎÊÌâÁË
ÎÒÓõÄÊÇJDK6.0+tomcat5.0+SQL2000 SP3+JDBC sp3
ËüÏÔʾµÄÊÇ
javax.servlet.ServletException: [Microsoft][SQLServer 2000 Driver fo ......
SELECT a.tguildname ,SUM(a.ct) + if (SUM(b.ct) IS NULL ,0,SUM(b.ct)) from (
SELECT tg.tguildname,c.cid, (
cf.fbb + cf.fgjbb + cf.fjybb + cf.fqb + cf.fgjqb + cf.fjyqb + cf.fqib + cf. ......