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

ACCESSʱ¼ä²éѯ£¬ÅжÏÎÊÌ⣬ÔÚÏßµÈ

Çë½Ì£º
  ±íA½á¹¹ÈçÏ£ºID StartTime EndTime
  1 2010/4/2 9:00:00 2010/4/2 11:00:00
  2 2010/4/2 12:00:00 2010/4/2 14:00:00
  . ... ...

  ÏÖÎÒÓµÓÐÁ½¸öʱ¼ä±äÁ¿a,b£¬ÔõÑù²éѯ¿ÉÒÔµÃÖªa,bËù×é³ÉµÄʱ¼ä¶ÎºÍ±íÖÐStartTime£¬EndTime¹¹³ÉµÄʱ¼ä¶Î²»³åÍ»£¿
  ÎÒÏëµ½µÄÊÇÕâÑù£º
  1.ÌÈÈôaСÓÚStartTimeÖÐ×îС£¬ÄÇôbÒ²Ó¦¸ÃСÓÚStartTimeÖÐ×îСµÄ¼Ç¼£¬Í¬Ê±bÓ¦¸Ã´óÓÚa£»
  2.ÌÈÈôa´óÓÚEndTimeÖÐ×î´ó£¬ÄÇôbÒ²Ó¦¸Ã´óÓÚEndTimeÖÐ×î´ó£¬Í¬Ê±bÓ¦¸Ã´óÓÚa£»
  3.ÌÈÈôa²»±ÈStartTimeÖÐ×îСµÄС£¬Ò²²»±ÈEndTimeÖÐ×î´óµÄ´ó£¬ÄÇôa²»Ó¦¸Ã´¦ÓÚÓÉStartTimeºÍEndTimeËù×é³ÉµÄÈÎÒâʱ¼ä¶ÎÄÚ£¨Õâ¸öÎÒ¿ÉÒÔͨ¹ýbetweenÅжϣ©£¬ÕâÖÖÇé¿öÏÂÎÒÓ¦¸ÃÔõÑù¶Ôb×öÅжÏÄØ£¿ÎÒµÄ˼·ÊDzé³öÀëa×î½üµÄStartTime£¬È»ºóbÓ¦¸ÃСÓÚ´ËStartTime£¬µ«¿É±¯µÄÊÇÎÒ²»ÖªµÀÔõÑùµÃµ½Àëa×î½üµÄStartTime£¨ÎÒ²»ÄÜÿ¸ö¶¼Ïë¼õÈ¡×îСֵ°É£¿£©£¬²»ÖªµÀACCESSÓÐûÌṩʲôʱ¼ä·½ÃæµÄº¯Êý¿É¹©µ÷Óã¬Çë¸øÓè°ïÖú¡£

¼ÅįµÄSF

û¿´¶®£¬½¨ÒéÄÜÓÃʵ¼ÊÀý×Ó˵Ã÷¡£

  ½¨ÒéÄãÁгöÄãµÄ±í½á¹¹£¬²¢Ìṩ²âÊÔÊý¾ÝÒÔ¼°»ùÓÚÕâЩ²âÊÔÊý¾ÝµÄËù¶ÔÓ¦ÕýÈ·½á¹û¡£
  ²Î¿¼Ò»ÏÂÕâ¸öÌù×ÓµÄÌáÎÊ·½Ê½http://topic.csdn.net/u/20091130/20/8343ee6a-417c-4c2d-9415-fa46604a00cf.html



¾ÍÊǶ©»áÒéÊÒ£¬¿ªÊ¼Ê±¼äºÍ½áÊøÊ±¼ä²»ÄܺÍÒÑ´æÔÚµÄʱ¼ä¶Î³åÍ»£¬Ó¦¸ÃÔõôÅжϷ½±ã

ÈýÂ¥ÒѾ­¸ø³ö´ð°¸ÁË¡£

ÒýÓÃ
ÈýÂ¥ÒѾ­¸ø³ö´ð°¸ÁË¡£

Ã²ËÆÕâÑù²»ÐаÉ<


Ïà¹ØÎÊ´ð£º

Vb.net Access CrystalReport - .NET¼¼Êõ / VB.NET

µÚÒ»´Î½Ó´¥CrystalReport
¼±Ñ°ÕÒVb.net Access ͨ¹ý²éѯ³öµÄÊý¾ÝÊä³öµ½CrystalReportµÄÀý×Ó.
ÓеÄÅóÓÑÂé·³·¢À´Ñ§Ï°.¶àл!
¸úÄãµÄÒªÇó²î²»¶à£¬²Î¿¼Ò»Ï£º
http://topic.csdn.net/u/20090823/21/87af02d3-f4ca-480 ......

tomcatÁ¬½ÓAccessÊý¾Ý¿âÎÊÌâ¡£ - Java / Web ¿ª·¢

¸÷λ¸ßÊֺã¬Âé·³°ïÎÒ¿´ÏÂÕâ¸öÊý¾Ý¿âÁ¬½ÓÎÊÌ⣺
×öÁËÒ»¸öBBSµ«ÊÇÊý¾Ý¿â¾ÍÊÇÁ¬½Ó²»ÉÏ¡£´íÎó´úÂëÈçÏÂ
HTTP Status 500 - 
------------------------------------------------------------------------------- ......

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

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ºÅ