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

ACCESSÆøËÀÎÒÁË£¬MD£¬×Ö¶ÎÖµ²»¶Ô

ÎÒÒª´ÓACCESS²éѯһÐÐÊý¾Ý,Êý¾Ý¿âÀïÓÐ ip£º192.168.2.71£¬192.168.2.55
SELECT COUNT(*) AS num from TreeNode WHERE ([ip]='192.168.2.55')£¬ÄÜÑ¡³öÊý¾ÝÀ´
SELECT COUNT(*) AS num from TreeNode WHERE ([ip]='192.168.2.71')£¬ËÀ»îÑ¡²»³öÊý¾ÝÀ´
ÕâÊÇΪʲô£¬Cao£¬ÆøËÀÁË£¬ÎÒÒÔΪÊÇ¿Õ¸ñÎÊÌ⣬µ«ÊÇÊÔ¹ýºÃÏñÓÖ²»ÊÇ£¬Ê²Ã´Ô­Òò°¡£¿£¿£¿£¿£¿

[ip] »»¸öÃû ¸Ä³Éip1 ipÊÇaccessÀïµÄ¹Ø¼ü×Ö

ÓÐûÓÐÈ«½Ç°ë½ÇµÄÎÊÌ⣬ÌرðÊÇIPµØÖ·ÖеÄ.·ûºÅ

ÒýÓÃ
[ip] »»¸öÃû ¸Ä³Éip1 ipÊÇaccessÀïµÄ¹Ø¼ü×Ö

´ó¸ç£¬¼ÓÉÏ[]¾ÍºÍ¹Ø¼ü´ÊÇø·Ö¿ªÁË£¬Õⶼ...£¬²»ÊÇÕâ¸öÎÊÌâ

ÊÇ·ñÕâÌõSQLÓï¾äÖ´ÐÐÍêµÄ½á¹û¾ÍÊǿյģ¿

ÒýÓÃ
ÊÇ·ñÕâÌõSQLÓï¾äÖ´ÐÐÍêµÄ½á¹û¾ÍÊǿյģ¿

Ñ¡³öµÄ½á¹ûÊÇ
num
0
¶øÓ¦¸ÃµÃµ½µÄÊÇ
num
1


°ï¶¥

û¿´µ½´úÂ룬±ÈÈçÓαêµÈÎÊÌâÄØ


ÒýÓÃ
û¿´µ½´úÂ룬±ÈÈçÓαêµÈÎÊÌâÄØ


¿É·ñÏêϸ˵˵ʲôÊÇ Óαê ÎÊÌâ°¡ £¿Ð»Ð»

È«°ë½ÇÎÊÌ⣿
½«sqlÓï¾ä¸´ÖƵ½accessÖÐÖ±½Ó²éѯ
½«¸Ã¾äɾµôÖØдһ±é

//ºÜ¶à¿ÉÄÜ°¡£¬¿´¿´Êý¾Ý¿âÖÐʵ¼ÊµÄÖµÊǶàÉÙ°É¡£
//·´Õý²»ÊÇACCESS°×³Õ¡£

ͬÒâÂ¥Éϵġ£


Ïà¹ØÎÊ´ð£º

access±íÖÐʱ¼ä²îµÄÉú³É

access±íÖÐÓÐ3¸ö×ֶΣ¬starttime£¬endtime£¬timespan£¬
ÊäÈëÇ°Á½¸öÖµºóÔõô×Ô¶¯Éú³ÉtimespanÄØ
´´½¨²éѯ¡£

select *, endtime-starttime from your table


»òÕßÔÚÄãµÄÊäÈë´°ÌåÖÐÓÃVBA´úÂëʵÏÖ¡ ......

accessÖÐlikeд·¨

sqlÓï¾äÊÇÕâÑùдµÃ 
string sql = "select * from shophistory where username(stringÀàÐÍ)¡¡like '%"+ name +"%' ";
½á¹ûÔËÐб¨´í£º(²Ù×÷·û¶ªÊ§) ÔÚ²éѯ±í´ïʽ  ˵ºó ......

Access導³öExecl

VB+Access×öµÄϵ統£¬
Ôõ樣°Ñ數據庫Access內ÈÝ導³öexecl£¿
ÏÖÔÚû¶«Î÷ÊÔ£¬´ÓÍøÉÏÕÒÁ˶δúÂëÄã¿´¿´
VB code:

Private Sub ExportOneTable()
'EXPORTS TABLE IN ......

Access´ø²ÎÊýµÄ²éѯ

ÔÚaccessÖÐÔõôִÐÐselect TOP (@size) * from table1
Õâ¸öTOPÔõô´ø²ÎÊý²éѯ°¡
ÓÃVBA¶¯Ì¬Éú³ÉSQLÓï¾ä£¬ÔÙÖ´ÐÐ

²»ÄÜÖ±½ÓÓÃSQLÓï¾ä£¬ÓÃ×Ö·û´®ÀÛ¼ÓÉú³ÉSQLÓï¾äµÄ·½·¨À´Ö´ÐÐSQLÓï¾ä

top n Õâ¸öûÓа취ʹÓò ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ