ΪʲôÎÒÒÔ»»ÐеÄÐÎʽд½øÁËAccessÊý¾Ý¿âÀïÃ棬¶ÁÈ¡³öÀ´µÄÊý¾ÝÈ´ÊÇûÓл»Ðеģ¿£¿
×Ô¶¯¹ýÂ˵ôÁË£¡
Ôõôд£¿£¿
ÄãÊÇÏëÔÚÒ³ÃæչʾµÄʱºòÏÔʾ»»ÐÐÂ𣿿ÉÒÔ½«<br>д½øÈ¥£¬Õ¹Ê¾µÄʱºòdecodehtml
ÊÇ°¡£¬ÎÒ×öµÄÊÇÐÂÎÅÒ³Ãæ¡£¡£ËùÒÔµÃչʾµÄʱºòÓл»ÐÐ
µ«ÊÇÎÒºǫ́±£´æÊý¾ÝµÄʱºòÓл»ÐС£
±ÈÈçÏÂÃæÊÇÎÒÒ ......
ÎÒ´ÓORACLE½«Ä³±íµ¼ÈëÖÁACCESSÖУ¬ÔÚACCESSÖÐʹÓÃSQLÈçÏ£º
select * into ouform from DEPT_DICT in [ODBC][ODBC;Driver={Microsoft ODBC for Oracle};UID=COMM;PWD=COMM;SERVER=TEST;]
Ö´Ðк󷵻ØÈçÏ´íÎó£¬ÇëÎÊÕâÊÇÔõô»ØÊ£¿ÈçºÎ½â¾ö£¿
¡°Microsoft Jet Êý¾Ý¿âÒýÇæÕÒ²»µ½ÊäÈë±í»ò²éѯ'DEPT_DICT'¡£È·¶¨ËüÊÇ·ñ´æÔÚ£¬Ò ......
ÔÚAccessÖÐ Ö´ÐÐ
SELECT * into bbbb from Tab1 IN [ODBC] [ODBC;Driver={Microsoft ODBC for Oracle};UID=PP;PWD=PP;SERVER=DDDSB;]
±¨´í ¡°Microsoft Jet Êý¾Ý¿âÒýÇæÕÒ²»µ½ÊäÈë±í»ò²éѯ'Tab1'¡£È·¶¨ËüÊÇ·ñ´æÔÚ£¬ÒÔ¼°ËüµÄÃû³ÆµÄƴдÊÇ·ñÕýÈ·¡£¡±È·¶¨´æÔÚTab1 ±í£¡
Ôõô½â¾ö°¡ ¼±¼±¼±
°ï°ïæ°¡ ºÜ¼±¡£
......
select a.Óû§±àºÅ as Óû§±àºÅ,a.Óû§Ãû³Æ as Óû§Ãû³Æ,a.ÇøÓò as ÇøÓò ,
a.µ¥¼Û as µ¥¼Û, isnull(b.±¾ÆÚÖ¸Êý,0) as ±¾ÆÚÖ¸Êý from yonghu a left join yongshui b on a.Óû§±àºÅ =b.Óû§±àÂë and not exists(select 1 from yongshui t where t.Óû§±àÂë=b.Óû§±àÂë and t.¼ÈëÈÕÆÚ>b.¼ÈëÈÕÆÚ)
......
select a.Óû§±àºÅ as Óû§±àºÅ,a.Óû§Ãû³Æ as Óû§Ãû³Æ,a.ÇøÓò as ÇøÓò ,
a.µ¥¼Û as µ¥¼Û, isnull(b.±¾ÆÚÖ¸Êý,0) as ±¾ÆÚÖ¸Êý from yonghu a left join yongshui b on a.Óû§±àºÅ =b.Óû§±àÂë and not exists(select 1 from yongshui t where t.Óû§±àÂë=b.Óû§±àÂë and t.¼ÈëÈÕÆÚ>b.¼ÈëÈÕÆÚ)
´ó¼ÒºÃ°¡£¬ÉÏ ......
ÒòΪ¹¤×÷ÐèÒª£¬Òª¿ª·¢Ò»¸ö¼òµ¥µÄÏúÊÛÊý¾Ý²éѯϵͳ£¬ÔÚACCESSÀïʹÓýçÃæÀ´²éѯ
Òª²éѯ²»Í¬µØÇø£¬²»Í¬²úÆ·£¬²»Í¬°ü×°µÄÏúÁ¿¡£Ï£Íû¸ßÊÖÓпÕÓàʱ¼äµÄ»°°ï°ïæ
»áµÄ¼ÓÎÒQ:553469964£¬¼ÛÇ®ºÍÐèÇóµÈÎÊÌâ¼ÓÎÒQºóϸ̸
jf..
Õâ¸öÌ«¼òµ¥ÁË£¬Äã×Ô¼º×ö¶¼ÐУ¬°Ñ±íÉè¼ÆºÃ¾Í¿ÉÒÔÁË
Èç¹û±ØÐëÒªÔÚAccessÖÐ×÷µÄ»°£¬ÄÇô¿ÉÒÔÔÚAccess ......