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

ACCESS ½¨Á¢¶à±íÎÊÌâ

ÎÒÏÖÔÚÒªÔÚÒ»¸öaccessÊý¾Ý¿âÀïÃæ½¨Á¢2¸ö±í
Ò»¸ödata1 Ò»¸ödata2£»
µ«Êǽ¨Á¢Íê³Éºó ÎÒ·¢ÏÖÒ»¸öÎÊÌâ
ÎÒÏȽ¨Á¢data1ºó ½«Êý¾Ýµ¼Èëºó ´óСΪ197M
ÔÚ½¨Á¢data2 µ¼ÈëÊý¾Ý ´óС»¹ÊÇ197M
ÕâÈÃÖ±½Óµ¼ÖÂÎÒ³ÌÐò²éѯ²»Òªdata2 ˵ÊÇdata2²»´æÔÚ
µ«ÊÇ ÎÒ´ò¿ªÊý¾ÝÃ÷ÏÔ¿´µ½ÁËdata2ÀïÃæµÄÊý¾Ý

µ«ÊÇÎÒµ¥¶À½«data1 ºÍdata2 ·ÅÔÚ²»Í¬µÄaccessÀïÃæ Ò»¸ö197 Ò»¸ö137

ÔÚÏßÇó¾È........
e ÖØÀ´Ã»Óùýaccess


ûÓöµ½¹ýÕâÖÖÇé¿ö


²Î¿¼£º
http://school.itzcn.com/special-spid-12.html
ÉÏÃæ½²½âµÄ±È½ÏÏêϸ£¬Ï£Íû¶ÔÂ¥Ö÷ÓÐËù°ïÖú¡£

ÎÊÌâ½â¾öÁË µ«ÊÇ´óСÎÒ»¹ÊǺÜÄÉÃÆ
µ¼ÈëÒ»¸ö±íºó´óСû±ä Ææ¼£ÁË


Ïà¹ØÎÊ´ð£º

½â¾öaccess¼¶Áª¸üÐÂÎÊÌâ - ÆäËûÊý¾Ý¿â¿ª·¢ / Access

CREATE TABLE Product(model integer, 
maker varchar(20), 
CONSTRAINT SAND PRIMARY KEY (model), 
CONSTRAINT PANDA FOREIGN KEY (model) REFERENCES PC (model) 
ON DELETE CASCADE ......

VCÁ¬½ÓACCESSÊý¾Ý¿âÎÊÌâ - VC/MFC / Êý¾Ý¿â

ÎÊÌ⣱
ÎÒÓÃADOÁ¬½ÓÉèÁËÓû§ÃûÃÜÂëµÄÊý¾Ý¿â
µ«ÊÇÎÒ·¢ÏÖÎÒ²»ÊäÈë Óû§ÃûºÍÃÜÂë ¶¼¿ÉÒÔÁ¬½Ó³É¹¦ ¶øÇÒ»¹ÄܰÑÊý¾Ý¶Á³öÀ´
¼ôÁËÒ»¸öÃûΪtestÊý¾Ý¿â ½¨ÁËÒ»¸öÃûΪpeopleµÄ±í 
¼ûÁËÒ»¸ö Óû§Ãû1234 ÃÜÂë1234 µÄ ......

ÓÃASP Ôõô½«EXCELµ¼Èëµ½ACCESS - Web ¿ª·¢ / ASP

ÎÊÌâÊÇÕâÑùµÄ,ÏÖÔÚÓÐÒ»¸ö¹¤×ʱí,ÊÇEXCELµÄ,ÎÒÒª°ÑËüµ¼ÈëACCESS,ÒòΪ Òª²éѯÿ¸öÈ˵Ť×Ê,¸ù¾Ý²»Í¬µÄ±àºÅ¿ÉÒÔ²éѯµ½Ïà¶ÔµÄÈË,
ÓÃASP Ôõô½«EXCELµ¼Èëµ½ACCESS,¶øÇÒÿÔ¶¼Óв»Í¬µÄ±í,

ÒýÓÃ
Æäʵ¾ÍÊǰÑEXCELµ±³ÉÊý ......

VC ADO ACCESS sql ²éѯ - VC/MFC / Êý¾Ý¿â

´ó¼Ò°ïÏÂæÁË
Çë½ÌÒ»¸öSQL²éѯµÄÎÊÌâ
±ÈÈçÎÒÏÖÔÚ²éѯ
SELECT * from XS WHERE רҵÃû='¼ÆËã»ú'
²éѯÍê³ÉÖ®ºóÎҿɲ»¿ÉÒÔÔÚÉϴβéѯµÄ»ù´¡Ö®ÉÏÔÚ½øÐÐÏà¹Ø²éÑ¯ÄØ£¿
±ÈÈçÎÒÔÚ²éÍê¼ÆËã»úרҵµÄËùÓÐѧÉúÖ®ºó£¬Ïë²é³ö¼ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ