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

ÔÚaccessÖеĸüÐÂÓï¾ä£¿

Òª°ÑÒ»ÕűíÖеÄÒ»¸ö×Ö¶ÎÁÐÖÐËùÓÐÊý¾Ý¸ÄΪ0
update tb set col=0

ÒýÓÃ
update tb set col=0

ÒòΪûÓÐÔõôÓùýaccess£¬¸Õ²ÅÊÇÁÐÃûд´íÁË¡£
»¹ÊÇллŶ...

ÒýÓÃ
Òª°ÑÒ»ÕűíÖеÄÒ»¸ö×Ö¶ÎÁÐÖÐËùÓÐÊý¾Ý¸ÄΪ0

update tb set col = 0

update Ò»Õűí set ×Ö¶Î=0;

ÀûÓÃAccessÖеĸüбí²éѯ¡£È»ºó¿´Ò»ÏÂ×óÉϽÇÓÐÒ»¸öÉè¼ÆÊÓͼµÄµØ·½£¬È»ºóµãÀïÃæµÄÒ»¸öSQLÊÓͼ¾Í¿ÉÒÔ¿´µ½ÉÏÃæ¸÷λд´úÂëµÄµØ·½ÁË¡£ ÉÏÊö£¬copyÏÂÀ´£¬¸ÄһϾÍOKÁË¡£


SQL code:
update tb set col = 0



Ïà¹ØÎÊ´ð£º

ÈçºÎ´ÓACCESSÊý¾Ý¿âÖÐÒ»´Î²éѯ¶à¸ö±í²¢¼ÓÈëÊý¾Ý¼¯?

ÔÚMSSQLÖУ¬ÎÒÃÇ¿ÉÒÔÒ»´Î²éѯ¶à¸öÊý¾Ý±í²¢¼ÓÈëµ½Êý¾Ý¼¯ÖУ¬ÖмäÖ»ÐèÓ÷ֺŸô¿ª£®È磺
£¢select * from A;select * from B;select * from C£¢,Ìî³äÊý¾Ý¼¯ºóÔÚDSÖоÍÓÐÁËÈýÕÅ±í£®
µ«ÔÚÓÃͬÑùµÄÓï¾ä·ÃÎÊACCESSÊý¾ ......

MFCÁ¬½ÓACCESS ³ö´í

Âé·³¸÷λ°ïæ¿´¿´°¡
´úÂëÈçÏ£º
CoInitialize(NULL);
  _ConnectionPtr pConn(__uuidof(Connection)); 
_RecordsetPtr pRst(__uuidof(Recordset));
pConn->ConnectionString="Provider ......

ÈçºÎÐÞ¸ÄACCESSϵͳ±í

ÈçºÎÐÞ¸Ämsysobjects±íÖеÄÊý¾ÝÄØ£¿Ð»Ð»
ɶ¶¼Ã»ÓÐ,Òâ˼²»Ã÷È·,ÔÙÏêϸµã°É

²»Òª¸ÄsysobjectsÀïµÄ¶«Î÷¡£
ÓÃÆäËü·½·¨¸Ä£¬±íÃû»òÆäËû¡£

ÒªÔÚACCESS»·¾³ÏÂÅäÖÃȨÏÞ£¬²ÅÄÜ·ÃÎÊϵͳ±í...

лл´ó¼Ò¡£
ÊÇÕâÑù£¬¿´ ......

accessÊÇ·ñÖ§³Öͬʱ²åÈë,¶ÁÈ¡,¶ÁÈ¡ºóɾ³ýµÄ²Ù×÷?

Òª×ö¸öÔ¶³ÌͨÐųÌÐò,²Ù×÷accessÊý¾Ý¿â,Õâ¸ö³ÌÐòÐèÒª¶ÁȡһÌõÊý¾Ý,È»ºó½«Æäɾ³ý.ÁíÍâÒ»¸ö³ÌÐòÒ²Òª²Ù×÷ͬһ¸öaccessµÄͬһ¸ö±í,´Ë³ÌÐòÒª½øÐвåÈë²Ù×÷.Á½¸ö³ÌÐò»áͬʱ²Ù×÷Ò»¸ö±í.ÎÒÏëÖªµÀͬʱ²Ù×÷accessµÄ»°,ÄÜÐÐÂð?
......

aspÍøÒ³ÏòaccessÊý¾Ý¿â²åÈë ÈÕÆÚÀàÐÍÎÊÌâ(¸ßÊÖ½ø)

ÎÒÔÚÇ°Ì¨Ò³ÃæÊäÈë¿òÊäÈë 20091208 µã»÷Ìá½»Ö®ºó±¨´í,˵ÀàÐͲ»Æ¥Åä.  
Êý¾Ý¿âÀï Õâ¸ö×ֶεĸñʽӦ¸ÃÊÇ 2009-12-8 14:27:40 
ÊDz»ÊÇÒª°Ñ 20091208 ת»»³É¸ñʽ 2009-12-8 14:27:40  
ÇëÎÊÎ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ