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

access¸´ÖƼǼ

accessÊý¾Ý¿âÀÏëÒªÔÚ´°ÌåÀï¸´ÖÆÒ»Ìõ¼Ç¼£¬±ÈÈ磺
µ±Ç°¼Ç¼ºÅΪ001£¬Ôڴ˽çÃæÀ°´Ò»¸ö°´Å¥£¬¾Í×Ô¶¯¸´ÖƳö¼Ç¼ºÅΪ002µÄÁíÍâÒ»Ìõ¼Ç¼¡£
Óð´Å¥Ïòµ¼ÀïµÄ¡°¸´ÖÆ¡±Ñ¡Ï×ÜÌáʾÓдúÂëΪ-2147352567£¨80020009£©µÄ´íÎó~~
ÇëÎÊÈçºÎʵÏÖÉÏÊö¹¦ÄÜÄØ£¿
docmd.runsql "insert into table1 select '002',col2,col3,col4 from table1 wher col1='001'"



ÒýÓÃ
docmd.runsql "insert into table1 select '002',col2,col3,col4 from table1 wher col1='001'"



¹ÖÎÒû˵Çå³þ£º²»ÊÇÿ´Î¶¼ÊÇ001£¬002~~
ÎÒµÄÒâ˼ÊÇ˵ÿ´Î±àºÅ×Ô¶¯¼Ó1~~

{{


Ïà¹ØÎÊ´ð£º

VCÁ¬½ÓACCESSÊý¾Ý¿âÎÊÌâ - VC/MFC / Êý¾Ý¿â

ÎÊÌ⣱
ÎÒÓÃADOÁ¬½ÓÉèÁËÓû§ÃûÃÜÂëµÄÊý¾Ý¿â
µ«ÊÇÎÒ·¢ÏÖÎÒ²»ÊäÈë Óû§ÃûºÍÃÜÂë ¶¼¿ÉÒÔÁ¬½Ó³É¹¦ ¶øÇÒ»¹ÄܰÑÊý¾Ý¶Á³öÀ´
¼ôÁËÒ»¸öÃûΪtestÊý¾Ý¿â ½¨ÁËÒ»¸öÃûΪpeopleµÄ±í 
¼ûÁËÒ»¸ö Óû§Ãû1234 ÃÜÂë1234 µÄ ......

dOOdads Á¬½Ó ACCESS µÄÊý¾Ý·ÖÒ³ÎÊÌâ

ÈçÌâ dOOdads Á¬½Ó ACCESS µÄÊý¾Ý·ÖÒ³ÎÊÌ⣡
ʹÓà dOOdads Á¬½Ó ACCESSÊý¾ÝµÄʱºò Êý¾Ý·ÖÒ³µÄÎÊÌ⣡
¸ù¾ÝÕâ¸ö¸Ä°É
C# code:

public static Product[] SearchProducts(string keyword, int categoryID, int pa ......

ÈçºÎÔÚVB.NET´´½¨accessÊý¾Ý¿â£¿

¸Õ¸Õ½Ó´¥VB.NET£¬¶Ô.NET»ù±¾Ê²Ã´Ò²²»¶®£¬Çë¸ßÊÖ¸øÒ»¶Î½ÏÍêÕû´´½¨accessÊý¾Ý¿âµÄʾÀý´úÂ룬ÈÃÎÒѧϰһÏ¡£
Ëùν½ÏÍêÕû´´½¨Êý¾Ý¿âʱ¶¨Òå¸÷¸ö×Ö¶ÎÀàÐ͵ıíʾ·½·¨£¬ÈçÕûÊýÐÍ£¬¸¡µãÐÍ£¬×Ö·ûÐÍ£¨¶¨Ò峤¶ÈÈçºÎ±íʾ£©¡£Ð»Ð» ......

ACCESSÖ§³ÖÁ¬½Ó³ØÂð - ÆäËûÊý¾Ý¿â¿ª·¢ / Access

¾ÍÊÇÊÇ·ñÖ§³Ö¶à¸öÁ¬½ÓµÄ²Ù×÷£¿ÔÚÒ»¸ö³ÌÐòÁ¬½ÓÕâ¸öÊý¾Ý¿âʱ£¬ÁíÒ»¸ö³ÌÐò»¹ÄÜÔÙÁ¬½ÓÕâ¸öÊý¾Ý¿âÂð£¿

×î¶àÖ§³Ö¶àÉÙ²¢·¢Á¬½Ó£¿

Ö§³Ö¡£
http://msdn.microsoft.com/en-us/library/ms810829.aspx

×î¶àÖ§³Ö¶àÉÙ²¢· ......

ACCESSÈ¥³ýÖØ¸´Öµ - ÆäËûÊý¾Ý¿â¿ª·¢ / Access

oracle ´úÂ룺
select * from (select * row_number() over ( partition by ÁªÏµºÅÂë order by ÒµÎñºÅÂë ) rn from ºÅÂë²éѯ) where rn<2
Ч¹ûÊÇ£º½« ijһָ¶¨×ֶΠɾ³ýÖØ¸´µÄºÅÂ룬²¢±£Áô¸ÃºÅÂëÏà¹ØµÄÆäËûÐ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ