·¢²¼ÈÕÆÚ£º2004-10-20
×÷ ÕߣºÖñµÑ(΢Èí×îÓмÛֵר¼Ò)
Õª Òª£ººó¶ËÓÃmdbºÍͨ¹ýODBCÁ´½ÓSQL SEVER2000ÔÚÑ¡Ôñ²éѯÖеÄÒ»¸ö²îÒìÐԱȽÏÓë½â¾ö·½·¨
Õý ÎÄ£º
1¡¢ÎÊÌâÖØÏÖ£º
ÔÚÒÔmdbÎļþΪºó¶ËµÄǰ̨³ÌÐòÖУ¬ÎÒʹÓÃÁËÏÂÃæµÄ²éѯ£º SELECT Sum(plan_quePrice5000.Ord_plan_qty) AS ÂäʵÁ¿, "5000ÒÔÉÏ" AS ¼Û¸ñ FROM plan_quePrice5000 GROUP BY "5000ÒÔÉÏ" WITH OWNERACCESS OPTION; ÔËÐÐÕý³£
ÔÚÒÔsql sever2000Ϊºó¶ËµÄǰ̨³ÌÐò£¬ÎÒʹÓÃÉÏÃæµÄ²éѯ£¬¾ÓÈ»³ö´í£¬Ëµµ÷ÓÃODBCʧ°Ü£¨×¢£º±íÊÇÒ»ÑùµÄ£©
2¡¢½â¾ö·½·¨£º ½«Ñ¡Ôñ²éѯµÄ¡°·Ö×顱¸ÄΪ¡°±í´ïʽ¡±£¬SQLÓï¾ä¸ÄΪ£º SELECT Sum(plan_quePrice5000.Ord_plan_qty) AS ÂäʵÁ¿, '5000ÒÔÉÏ' AS ¼Û¸ñ FROM plan_quePrice5000;
3¡¢×ܽ᣺ ÒÔÉÏÃæµÄ²éѯ¹¦ÄÜΪÀý£¬ÔÚºó¶ËΪmdbʱ£¬ÔÚÉÏÃæµÄÑ¡Ôñ²éѯ¿ÉÒÔʹÓá°·Ö×顱£¬¶øÊÇÒÔsql sever2000Ϊºó¶Ëʱ£¬²»ÄÜʹÓá°·Ö×顱£¬¶øÖ»ÄÜʹÓá°±í´ïʽ¡±À´ÊµÏÖ
|