Ò׽ؽØͼÈí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB
ÈÈÃűêÇ©£º c c# c++ asp asp.net linux php jsp java vb Python Ruby mysql sql access Sqlite sqlserver delphi javascript Oracle ajax wap mssql html css flash flex dreamweaver xml
 ×îÐÂÎÄÕ : access

д½øAccessµÄÊý¾ÝºÍ¶ÁÈ¡Êý¾Ý - .NET¼¼Êõ / ASP.NET

ΪʲôÎÒÒÔ»»ÐеÄÐÎʽд½øÁËAccessÊý¾Ý¿âÀïÃ棬¶ÁÈ¡³öÀ´µÄÊý¾ÝÈ´ÊÇûÓл»Ðеģ¿£¿
×Ô¶¯¹ýÂ˵ôÁË£¡

Ôõôд£¿£¿

ÄãÊÇÏëÔÚÒ³ÃæչʾµÄʱºòÏÔʾ»»ÐÐÂ𣿿ÉÒÔ½«<br>д½øÈ¥£¬Õ¹Ê¾µÄʱºòdecodehtml

ÊÇ°¡£¬ÎÒ×öµÄÊÇÐÂÎÅÒ³Ãæ¡£¡£ËùÒÔµÃչʾµÄʱºòÓл»ÐÐ

µ«ÊÇÎÒºǫ́±£´æÊý¾ÝµÄʱºòÓл»ÐС£
  ±ÈÈçÏÂÃæÊÇÎÒÒ ......

ÈçºÎÔÚACCESSÖзÃÎÊORACLE£¿ - Oracle / »ù´¡ºÍ¹ÜÀí

ÎÒ´Ó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ÖзÃÎÊORACLE£¿

ÔÚAccessÖÐ Ö´ÐÐ
SELECT * into bbbb from Tab1 IN [ODBC] [ODBC;Driver={Microsoft ODBC for Oracle};UID=PP;PWD=PP;SERVER=DDDSB;]
 ±¨´í ¡°Microsoft Jet Êý¾Ý¿âÒýÇæÕÒ²»µ½ÊäÈë±í»ò²éѯ'Tab1'¡£È·¶¨ËüÊÇ·ñ´æÔÚ£¬ÒÔ¼°ËüµÄÃû³ÆµÄƴдÊÇ·ñÕýÈ·¡£¡±È·¶¨´æÔÚTab1 ±í£¡
Ôõô½â¾ö°¡ ¼±¼±¼±
°ï°ïæ°¡ ºÜ¼±¡£
......

access sqlÓï¾ä±àÒ벻ͨ°¡ - Delphi / Êý¾Ý¿âÏà¹Ø

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 sqlÓï¾ä±àÒ벻ͨ°¡ - ÆäËûÊý¾Ý¿â¿ª·¢ / Access

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¸ßÊÖ×öÒ»¸öϵͳ - ÆäËûÊý¾Ý¿â¿ª·¢ / Access

ÒòΪ¹¤×÷ÐèÒª£¬Òª¿ª·¢Ò»¸ö¼òµ¥µÄÏúÊÛÊý¾Ý²éѯϵͳ£¬ÔÚACCESSÀïʹÓýçÃæÀ´²éѯ
Òª²éѯ²»Í¬µØÇø£¬²»Í¬²úÆ·£¬²»Í¬°ü×°µÄÏúÁ¿¡£Ï£Íû¸ßÊÖÓпÕÓàʱ¼äµÄ»°°ï°ïæ
»áµÄ¼ÓÎÒQ:553469964£¬¼ÛÇ®ºÍÐèÇóµÈÎÊÌâ¼ÓÎÒQºóϸ̸

jf..

Õâ¸öÌ«¼òµ¥ÁË£¬Äã×Ô¼º×ö¶¼ÐУ¬°Ñ±íÉè¼ÆºÃ¾Í¿ÉÒÔÁË

Èç¹û±ØÐëÒªÔÚAccessÖÐ×÷µÄ»°£¬ÄÇô¿ÉÒÔÔÚAccess ......
×ܼǼÊý:990; ×ÜÒ³Êý:165; ÿҳ6 Ìõ; Ê×Ò³ ÉÏÒ»Ò³ [10] [11] [12] [13] 14 [15] [16] [17] [18] [19]  ÏÂÒ»Ò³ βҳ
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ