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();//¹Ø±ÕÓëÊý¾Ý¿âµÄÁ¬½Ó
Ïà¹ØÎÊ´ð£º
with adod_dict do begin close; commandtext:='select bgqxcode,count(*) wjsl from wscl_wsda_file where wjnd=:tnd group by bgqxcode'; ......
sql2005 select *from v_ddxx where d_sfsc='0' and (g_ssbm='1001' or g_ssbm='1002') and (xxf>0 and xxfwzf <>0 ),Ö´ÐÐËÙ¶ÈÂýµÄÒªËÀ£¬µ«ÊÇÈç¹û°Ñ(xxf>0 and ......
´ó¼Ò°ïæ¿´¿´Õâ2¸ösqlÓï¾äÄĸö²éѯµÄËٶȸü¿ìµã¡£Ð»Ð»°ïæ¡£±È½Ï׿±¡£ÔÚ×öÐÔÄܲâÊÔ¡£ select * from ±íA LEFT OUTER JOIN ±íB ON (±íA.id || ' ' =±íB.id) ,±íC , ±íD, ±íE WhereÆäËûÌõ¼þ select * ......
Êý¾Ý±í¡¾biao¡¿£¬ ×ֶΣºid¡¢myname¡¢mytxt mytxtÄÚÈݸñʽÐÎÈ磺n|abcd¡££¨ÀýÈ磺1|ÁõµÂ»ª£¬2|Èδﻪ£¬3|αÌϼ£¬4|Âõ¿Ë@½Ü¿ËÑ·£© ÎÒÏÖÔÚÏ£Íû¶Á¼Ç¼³öÀ´ºó£¬°´ÕÕ[mytxt]×Ö¶ÎÀïµÄÊúÏߣ¨|£©Ç°ÃæµÄÄǸöÊý× ......
table1 Ãû³Æ Èë¿âÊý CT»ú 3 CT»ú 5 X¹â»ú 4 ......