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

Access ÊÇ·ñ Ò»´ÎÖ´ÐжàÌõSqlÓï¾ä ¡£

Access ÊÇ·ñ Ò»´ÎÖ´ÐжàÌõSqlÓï¾ä ¡£


insert into ...
update .
delete .

ÊÇ·ñ¿ÉÒÔ Ò»´ÎÖ´ÐÐ ¡£

=================

Íû¸ßÊÖÖ¸µã ¡£¡£¡£
²»Ö§³Ö£¬Ò»ÌõÒ»ÌõµØÖ´ÐÐ

лл WWWWA ¡£

ÓдóÁ¿µÄ Êý¾ÝÐèÒª²åÈë ¡£ ÓÐûÓÐ ¿ÉÒÔÌá¸ß ЧÂ浀 ½¨Òé ¡£

¡£

ÒýÓÃÓдóÁ¿µÄ Êý¾ÝÐèÒª²åÈë ¡£ ÓÐûÓÐ ¿ÉÒÔÌá¸ß ЧÂ浀 ½¨Òé ¡£


Äã¿ÉÒÔÔÚACCESSµÄVBAÖÐͨ¹ý³ÌÐòÒ»´ÎÐÔÌá½»¶àÍâSQL

currentproject.connection.execute "insert into ...."
currentproject.connection.execute "insert into ...."
...
currentproject.connection.execute "insert into ...."



Ïà¹ØÎÊ´ð£º

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

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

jspÁ´½Ósql2000µÄÒÉÎÊ£¿



type Exception report


message

description The server encountered an internal error () that prevented it from fulfilling this request.

exception

org.apache.jas ......

Access²éÕÒÖØ¸´ÎÊÌâ - ÆäËûÊý¾Ý¿â¿ª·¢ / Access

ÎÒÓÃAccessÊý¾Ý¿â×öÁËÒ»¸öͼÊéÊý¾Ý¿â£¬ÀïÃæÓÐÒ»¸ö×Ö¶ÎÊÇISBN£¬¾ÍÊÇISBNºÅ£¬µ«ÊÇÖ»µÄÒ»×Ü·ÖͼÊéдµÄISBNºÅ£¬ÓеÄûд£¬Ð´µÄÄÇÒ»²¿·ÖÓеÄISBNÊÇÖØ¸´µÄ£¬ÄÜ·ñÓÃSQLÓïÑÔ°ÑÖØ¸´µÄ¹ýÂ˵ô£¬µ«Ã»Ð´ISBNºÅµÄͼÊé²»ÄܹýÂ˵ô£¬È ......

sql ´æ´¢¹ý³Ì

ÎÒÒª×öÒ»¸ö¶¨µãʼþ£¬ÊÇÿÌìÍíÉÏ12µã¾Í°ÑÈý¸ö±íÀïµÄÐÅÏ¢·ÅÈëÒ»¸ö±íÀÎÒÏëÓô洢¹ý³ÌÀ´Ð´£¬ÔõÃ´Ð´ÄØ£¿£¬ÄÇλ¸ßÊÖ°ï°ïæ°É£¬·Ç³£¸Ðл£¡

Óû§ÃûÊÇΨһµÄ
±íA  ×Ö¶Î
Óû§Ãû£ºName  ,ÓÊÏ䣺Ema ......

Ò»Ìõsql²éѯÓï¾ä

ÌâÄ¿£º°Ñ¡°SC¡±±íÖС°Ò¶Æ½¡±ÀÏʦ½ÌµÄ¿ÎµÄ³É¼¨¶¼¸ü¸ÄΪ´Ë¿Î³ÌµÄƽ¾ù³É¼¨£» 
sqlÓï¾ä£º
  update SC set score=(SELECT avg(SC_2.score)  
  from SC SC_2  
  WHERE S ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ