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±êÁ¿º¯Êý¡£ ÒýÓà ×
Ïà¹ØÎÊ´ð£º
ÎÊÌâÈçÏ£º ÓòéѯÓï¾ä select * from tab where fil like 'CK090902'ÄܲéÕÒ³öÒ»Ìõ¼Ç¼²¢ÏÔʾ³öÀ´ ¸ÄΪ select * from tab where fil = 'CK090902' ¾Í²»ÄܲéÕÒµ½£¬Ò²ÏÔʾ²»³öÀ´ ......
ÈçÌâÔÚÎÒ´ò¿ªaccessÐ޸ĵÄʱºò±¨´í ÎÒ×°µÄGhost µÄXP°æ sp3µÄ²¹¶¡ ´íÎóÇ©Ãû AppName: msaccess.exe AppVer: 11.0.8166.0 AppStamp:46437912 ModName: pintlgnt.ime&n ......
ÓÃADO²Ù×÷AccessÊý¾Ý¿â£¬ÎªÊ²Ã´°Ñ¼Ç¼ɾ³ýÖ®ºó£¬»¹ÄÜÔÙ²éѯ³öÀ´£¿ Á´½ÓÓï¾ä Provider=Microsoft.Jet.OLEDB.4.0;Data Source= 'MyDataBase' ɾ³ýÓï¾ä delete from MyTable where ID = 100 1. ......
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 ......
string connectionString = ConfigurationManager.AppSettings["ConnectionString"]; string sql = "insert into times(time) values('" + DateTime.Now + ......