Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö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°×³Õ¡£

ͬÒâÂ¥Éϵġ£


Ïà¹ØÎÊ´ð£º

ODBC Microsoft accessµÇ¼ʧ°Ü

н¨µ¥Îĵµ³ÌÐòÑ¡ÔñODBCÖеÄÊý¾ÝԴʱ×ÜÊǵ¯³öÒ»¸öµÇ¼´°¿ÚÒªÊÚȨ¡£¡£¡£»¹ÒªÃÜÂë¡£¡£¡£
      ÆäËûµÄµ÷ÓÃODBCÖеÄÊý¾ÝÔ´ÊǾͲ»ÐèÒªÕâ¸ö£¬¿ÉÒÔÔËÐС£
  ŪÁ˺ó¤Ê±¼äÁË¡£¡£¡£
ûÓö¼û¹ý£¬¿ ......

ACCESSÖн¨Á¢Çл»±íµ¥Ê±Óöµ½ÎÊÌâ ÔÚÏßµÈ

ACCESSÖн¨Á¢Çл»±íµ¥,
µã»÷ ¹¤¾ß/×ÊÁϿ⹫ÓóÌʽ/Çл»±íµ¥¹ÜÀíÔ± ºó
Ìáʾ£ºMicrosoft office accessÎÞ·¨½¨Á¢visual basicÄ£×飡
µ½µ×ÊdzöÁËʲ÷áÎÊÌâÄØ£¿
µÚÒ»´ÎÕâÑù½¨Á¢Çл»±íµ¥ÊÇ¿ÉÒԵ쬵«ÊÇÓÉÓÚÓÐ ......

Çë¸øÒ»¸öACCESS¶àÌõ¼þ²éѯµÄÀý×Ó

Çë¸øÒ»¸öACCESS¶àÌõ¼þ²éѯµÄÀý×Ó,×Ö¶Î:ÐÕÃû,µç»°,¹«Ë¾,µØÖ·Îª²éѯÌõ¼þ,Ö»Òª²»Îª¿Õ,¾Í×÷Ϊ²éѯÌõ¼þ.
ÄãÏÈ給這個Щ×Ö¶Î設ÖÃ變Á¿並賦³õÖµ為:%,
ÔÙÔÚ²é詢 ......

ÈçºÎΪaccessÊý¾Ý¿â¼ÓÃÜ

¸øaccessÊý¾Ý¿â¼ÓÃܵIJ½ÖèÈçÏ£º

£¨1£©´ò¿ªaccessÈí¼þ£¬½çÃæÈçͼ1Ëùʾ

       

                        ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ