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

accessÖÐlike¸ÃÔõôÓã¿

RT,
ʹÓÃADODB·ÃÎÊAccessµÄÊý¾Ý±í£¬Ñ¡³ö°üº¬×Ö´®abcµÄ¼Ç¼
select * from MyTable where Field1 like ...
likeºóÃæ¸ÃÔõôд£¿

ËÆºõaccessÖеÄSQLÊÓͼÄÇÄܹ»Ö´ÐУ¬¶ø°³Ê¹ÓÃADODBÁ¬½ÓºóÖ´ÐÐÈ´²»ÐС£¡£

ÍøÉϲé,likeµÄÓï·¨ËÆºõÓкöàºÃ¶à¡£¡£²»ÖªµÀ¸Ã´ÓÄÄÀïÕÒ¡£¡£

SQLServerºÍAccessÓÐÉ¶Çø±ð£¿SQLÓÖÊÇʲô£¿ºÃÏóSQLÓÃÔÚ²»Í¬µÄÊý¾Ý¿âд·¨¶¼²îºÃ¶à¡£¡£¡£

Nz()ÊÇAccessÖеĺ¯Êý£¬¶øÓÃADODB·ÃÎÊʱֻÄÜÓÃiif(),isnull()Ö®Àà´úÌæ¡£¡£¸Ð¾õºÃ»ìÂÒ¡£¡£

×îºóÒ»¸öÎÊÌ⣬ҪѧÊý¾Ý¿â·½ÃæµÄ¶«Î÷£¬¸ÃÔõô×ÅÊÖ£¿ÓÐûÀàËÆMSDNµÄ¶«Î÷¿ÉÒԲ飿¸Ã´ÓÄÄÀï¿´Æð£¿

È«²¿·Ö¶¼¸øÁË£¬Ö»Çó¸øµãÌáʾ¡£

ÒýÓÃÍøÉϲé,likeµÄÓï·¨ËÆºõÓкöàºÃ¶à¡£¡£²»ÖªµÀ¸Ã´ÓÄÄÀïÕÒ¡£¡£


ACCESSµÄ°ïÖúÖÐÓÐJET-SQLµÄÓï·¨½éÉÜ¡£ ÿÖÖÊý¾Ý¿â¶¼²»Ì«Ò»Ñù£¬½¨ÒéÄã¿´°ïÖú¡£


ÒýÓÃSQLServerºÍAccessÓÐÉ¶Çø±ð£¿SQLÓÖÊÇʲô£¿ºÃÏóSQLÓÃÔÚ²»Í¬µÄÊý¾Ý¿âд·¨¶¼²îºÃ¶à¡£¡£¡£

Çø±ðÌ«¶àÁË£¬¿ÉÒÔдÉϼ¸Ç§×Ö¡£½¨ÒéÄãÖ±½ÓÔÚGOOGLEËÑË÷һϡ£
SQL Äã¿ÉÒÔÔÚGOOGLEËÑË÷һϣ¬½á¹¹»¯²éѯÓïÑÔ¡£°Ù¶ÈÖÐÒ²Ò»Ñù¡£»òÕßά»ù¡£

ºÃÏóSQLÓÃÔÚ²»Í¬µÄÊý¾Ý¿âд·¨¶¼²îºÃ¶à , ÊÇµÄ ²»Í¬³§¼Ò¶ÔSQL 92/2002 µÄ±ê×¼Àí½âµÃ²¢²»Ò»Ñù£¬²¢ÇÒ¶¼Ï²»¶¼ÓÈëһЩ×Ô¼ºµÄ¶«Î÷±ÈÈ纯Êý¡£ËùÒÔÄãÒª¿´¸÷×ÔµÄÎĵµ¡£

ÒýÓÃNz()ÊÇAccessÖеĺ¯Êý£¬¶øÓÃADODB·ÃÎÊʱֻÄÜÓÃiif(),isnull()Ö®Àà´úÌæ¡£¡£¸Ð¾õºÃ»ìÂÒ¡£¡£

ODBC±êÁ¿º¯Êý¡£


ÒýÓÃ×


Ïà¹ØÎÊ´ð£º

access ²éѯ¼Ç¼µÄÎÊÌâ?

ÎÊÌâÈçÏ£º

ÓòéѯÓï¾ä
select * from tab where fil like 'CK090902'ÄܲéÕÒ³öÒ»Ìõ¼Ç¼²¢ÏÔʾ³öÀ´
¸ÄΪ
select * from tab where fil = 'CK090902'
¾Í²»ÄܲéÕÒµ½£¬Ò²ÏÔʾ²»³öÀ´ ......

access²»ÄÜÐÞ¸ÄÄÚÈÝ

ÈçÌâÔÚÎÒ´ò¿ªaccessÐ޸ĵÄʱºò±¨´í
ÎÒ×°µÄGhost µÄXP°æ sp3µÄ²¹¶¡
´íÎóÇ©Ãû
AppName: msaccess.exe      AppVer: 11.0.8166.0    AppStamp:46437912
ModName: pintlgnt.ime&n ......

ACCESS¼Ç¼ɾ³ýºó»¹Äܲéѯµ½

ÓÃADO²Ù×÷AccessÊý¾Ý¿â£¬ÎªÊ²Ã´°Ñ¼Ç¼ɾ³ýÖ®ºó£¬»¹ÄÜÔÙ²éѯ³öÀ´£¿

Á´½ÓÓï¾ä Provider=Microsoft.Jet.OLEDB.4.0;Data Source= 'MyDataBase'
ɾ³ýÓï¾ä delete from MyTable where ID = 100

1. ......

ÈçºÎ°ÑÕâ¾ä¸Ä³ÉÔÚaccessÀïÕý³£ÔËÐеÄ?

select max(classname) as classname,max(parentpath) as parentpath,max(rootid) as rootid,max(classid) as classid from prodclass where parentpath like '%0,3%' and Child=0 group by classname order ......

ΪɶÎÒ²åÈëaccessÊý¾Ý¿âÓÐÎÊÌâ

string connectionString = ConfigurationManager.AppSettings["ConnectionString"];
        string sql = "insert into times(time) values('" + DateTime.Now + ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ