Ò׽ؽØͼÈí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

access ÖÐÖ´ÐÐsqlÓï¾äupdate²»³É¹¦£¬ÇóÖú£¡£¡£¡

access ÖÐÖ´ÐÐsql updateÓï¾äʱÓÐʱºò³É¹¦ÓÐʱºò²»³É¹¦£¬µ«ÊÇaccessÖв»³ö´íÎóÐÅÏ¢£¬²»ÖªµÀÊÇʲôԭÒò£¬ÓÐÄÄλ´óÏÀÖªµÀ£¬Çë°ïæ°¡
ÌùSQLÓï¾ä£¬¼ì²é±í¡¢×ֶεÄÓÐЧÐÔÉèÖÃ

sql ÔÚ²éѯ·ÖÎöÆ÷ÀïÃæ Ö´ÐкÜÕý³£

ÊÇACCESS»¹ÊÇSQLSERVER£¿
¼ì²éÒ»ÏÂûÓб»¸üеÄ×Ö¶Î

ÊÇÔÚaccessÀïÃæ Á¬½Ósqlserver È»ºóÖ´ÐÐsql update Óï¾ä£¬ÓÐʱºòÄܳɹ¦£¬ÓÐʱºò²»³É¹¦£¬Äܳɹ¦ËµÃ÷²»ÊÇÓï¾äºÍ¸üÐÂ×ֶεÄÎÊÌ⣬µ«ÊÇÓÐʱºò²»³É¹¦ÎÒ¾ÍÃÔºýÁË¡£¡£¡£¡£ÓôÃÆÖС£¡£¡£¡£

´Ó³ÌÐòÖÐÖ´ÐгöÀ´µÄsql Äõ½²éѯ·ÖÎöÆ÷ÀïÖ´ÐÐÍêȫûÓÐÎÊÌ⣬µ«¾ÍÊdzÌÐòÖ´ÐÐÍêÁË£¬Ã»ÓиüС£¡£¡£

ÓÃVBA¸üУ¿ÔÚʲôÇé¿öϳɹ¦¡¢²»³É¹¦£¿ÄãÒª×ܽáһϣ¬¾ÍÄ¿Ç°ÄãÌṩµÄ×ÊÁÏ£¬ÎÞ·¨ÅжÏ

ÍêÈ«ÏàͬµÄÇé¿öÏ£¬ÓÐʱºòÖ´Ðоͳɹ¦£¬ÓÐʱºò¾Í²»³É¹¦

ÄãµÄÓï¾äÊÇʲô£¿

²»³É¹¦£¬ÄãÊÇÈçºÎÀ´È·¶¨µÄ£¿ ½¨ÒéÀûÓÃdebugÀ´´ò³öÄãÖ´ÐеÄSQLÓï¾ä¡£ »¹ÓоÍÊÇÓÐûÓÐÆôÓÃÊÂÎñ£¿

ÎÒÀ´¶¥

ÒýÓÃ
ÊÇÔÚaccessÀïÃæ Á¬½Ósqlserver È»ºóÖ´ÐÐsql update Óï¾ä£¬ÓÐʱºòÄܳɹ¦£¬ÓÐʱºò²»³É¹¦£¬Äܳɹ¦ËµÃ÷²»ÊÇÓï¾äºÍ¸üÐÂ×ֶεÄÎÊÌ⣬µ«ÊÇÓÐʱºò²»³É¹¦ÎÒ¾ÍÃÔºýÁË¡£¡£¡£¡£ÓôÃÆÖС£¡£¡£¡£


ÔÚaccessÀïÃæÁ¬½Ósqlserver£¿£¿£¿£¿£¿

Ìù³öÓï¾ä°É£¬·ñÔòºÜÄÑ·ÖÎöµÄ

Óï¾äÄØ?

ÄãÖ´ÐÐÁËÏÂÃæÕâ¾ä»°ÁËÂð£¿

String conURL="jdbc:odbc:***";
Connection con=DriverManager.getConnection(conURL);

con.close();//¹Ø±ÕÓëÊý¾Ý¿âµÄÁ¬½Ó




Ïà¹ØÎÊ´ð£º

Á½¸öµ¼¹¹sql serverÊý¾Ý¿â,Êý¾Ýµ¼Èëµ¼³öÎÊÌâ

ÏÖÔÚÓÐÁ½¸öÒì¹¹µÄsql serverÊý¾Ý¿â,ÎÒÏ뽫µÚÒ»¸ö±íÖеÄÊý¾Ýµ¼Èëµ½µÚ¶þ¸ö±íÖÐ,×Ô¼ºÖ¸¶¨µ¼ÈëÊý¾ÝµÄ×Ö¶Î,ÈçºÎµ¼ÈëÊý¾ÝÄØ,´ó¼ÒÌÖÂÛÒ»ÏÂ?
dts¹¤¾ß

µ¼Èëµ¼³ö¹¤¾ß.

DD

¹þ¹þ£¬¹À¼ÆÕâλÊǵØQIOU¶¼Êܲ»Á˵Ä

Ö±½ÓÐ ......

¹ØÓÚgroup byµÄsqlÓï¾ä£¿

  with adod_dict do
    begin
    close;
    commandtext:='select bgqxcode,count(*) wjsl from wscl_wsda_file where wjnd=:tnd group by bgqxcode'; ......

sql²éѯÒÉÎÊ

±íÖа´datadate,tradeidΪÖ÷¼ü£¬Ò²¾ÍÊÇ˵tradeid»áÖظ´³öÏÖÔÚ²»Í¬ÌìÖУ¬Í¬Ò»ÌìµÄtradeidÊDz»Í¬µÄ¡£ÏÖÔÚÎÒÏ£ÍûÈ¡Ò»¶Îʱ¼ä·¶Î§ÄÚ²»Öظ´µÄtradeid£¬ÇÒֻҪÿ¸ötradeidµÄ×îºóÒ»´Î³öÏÖµÄÄÇÌõ¡£sqlÓï¾ä¸ÃÔõôд

£º ......

SQLÓï¾äЧÂÊÎÊÌâ - ÆäËûÊý¾Ý¿â¿ª·¢ / ÆäËûÊý¾Ý¿â

´ó¼Ò°ïæ¿´¿´Õâ2¸ösqlÓï¾äÄĸö²éѯµÄËٶȸü¿ìµã¡£Ð»Ð»°ïæ¡£±È½Ï׿±¡£ÔÚ×öÐÔÄܲâÊÔ¡£
select * from
  ±íA LEFT OUTER JOIN ±íB ON (±íA.id || ' ' =±íB.id) ,±íC , ±íD, ±íE
WhereÆäËûÌõ¼þ
select * ......

sqlÓï¾äÖÐÄܲ»ÄÜÕâÑùÅÅÐò£¿

Êý¾Ý±í¡¾biao¡¿£¬
×ֶΣºid¡¢myname¡¢mytxt
mytxtÄÚÈݸñʽÐÎÈ磺n|abcd¡££¨ÀýÈ磺1|ÁõµÂ»ª£¬2|Èδﻪ£¬3|αÌϼ£¬4|Âõ¿Ë@½Ü¿ËÑ·£©

ÎÒÏÖÔÚÏ£Íû¶Á¼Ç¼³öÀ´ºó£¬°´ÕÕ[mytxt]×Ö¶ÎÀïµÄÊúÏߣ¨|£©Ç°ÃæµÄÄǸöÊý× ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ