accessº¯Êý²Î¿¼
ÈÕÆÚ/ʱ¼ä
CDate ½«×Ö·û´®×ª»¯³ÉΪÈÕÆÚ select CDate("2005/4/5")
Date ·µ»Øµ±Ç°ÈÕÆÚ
DateAdd ½«Ö¸¶¨ÈÕÆÚ¼ÓÉÏij¸öÈÕÆÚselect dateAdd("d",30,Date())½«µ±Ç°ÈÕÆÚ¼ÓÉÏ30Ìì,ÆäÖÐd¿ÉÒÔ»»Îªyyyy»òHµÈ
DateDiff ÅжÏÁ½¸öÈÕÆÚÖ®¼äµÄ¼ä¸ô select DateDiff("d","2006-5-1","2006-6-1")·µ»Ø31,ÆäÖÐd¿ÉÒÔ»»Îªyyyy,m,HµÈ
DatePart ·µ»ØÈÕÆÚµÄij¸ö²¿·Ö select DatePart("d","2006-5-1")·µ»Ø1,¼´1ºÅ£¬dÒ²¿ÉÒÔ»»Îªyyyy»òm
Day ·µ»ØÈÕÆÚµÄd²¿·Ö,µÈͬÓÚdatepartµÄd²¿·Ö
Hour ·µ»ØÈÕÆÚµÄСʱ
IsDate ÅжÏÊÇ·ñÊÇÈÕÆÚ,ÊÇÈÕÆÚ·µ»Ø-1,²»ÊÇÈÕÆÚ·µ»Ø0
Minute ·µ»ØÈÕÆڵķÖÖÓ²¿·Ö
Month ·µ»ØÈÕÆÚµÄÔ·ݲ¿·Ö
Now ·µ»Øµ±Ç°Ê±¼ä(ÍêÕûʱ¼ä£¬°üÀ¨ÄêÔÂÈÕ Ð¡Ê±·ÖÃë)
Second ·µ»ØÈÕÆÚµÄÃ벿·Ö
Time ·µ»Øµ±Ç°µÄʱ¼ä²¿·Ö(¼´³ýÈ¥Äê/ÔÂ/ÈյIJ¿·Ö)
Weekday ·µ»Øij¸öÈÕÆڵĵ±Ç°ÐÇÆÚ(ÐÇÆÚÌìΪ1,ÐÇÆÚһΪ2,ÐÇÆÚ¶þΪ3...)£¬ÀýÈçselect weekday(now());
Year ·µ»Øij¸öÈÕÆÚµÄÄê·Ý
¡ø¼ì²é
IsEmpty ¼ì²âÊÇ·ñΪ¿Õ(²»¹ý¾²âÊÔ£¬²»¹ÜʲôÇé¿ö£¬¶¼·µ»Ø0)
IsNull ¼ì²âÊÇ·ñΪNullÖµ£¬nullÖµ·µ»Ø0£¬·ÇnullÖµ·µ»Ø-1
IsNumeric ¼ì²âÊÇ·ñΪÊý×Ö,ÊÇÊý×Ö·µ»Ø-1£¬·ñÔò·µ»Ø0
ËãÊõ
Abs ¾ø¶ÔÖµ
Atn ·µÕýÇÐÖµ¡£
Cos ÓàÏÒÖµ
Exp ·µ»Ø e µÄ¸ø¶¨´ÎÃÝ¡£
Fix ·µ»ØÊý×ÖµÄÕûÊý²¿·Ö(¼´Ð¡Êý²¿·ÖÍêÈ«½Øµô)
Int ½«Êý×ÖÏòÏÂÈ¡Õûµ½×î½Ó½üµÄÕûÊý¡£(ÆäʵµÈͬÓÚFix)
Log ·µ»ØÒÔEΪµ×µÄ¶ÔÊýÖµ
Rnd ·µ»ØÒ»¸ö0µ½1Ö®¼äµÄËæ»úÊýÖµ
Sgn ·µ»ØÊý×ÖµÄÕý¸º·ûºÅ(ÕýÊý·µ»Ø1,¸ºÊý·µ»Ø-1,0Öµ·µ»Ø0)
Sin ÕýÏÒÖµ
Sqr ·µ»Øƽ·½¸ùÖµ
Tan ÕýÇÐÖµ
¡ø³ÌÐòÁ÷³Ì
Choose ¸ù¾ÝµÚÒ»²ÎÊý£¬·µ»ØºóÃæ×Ö·û´®×éµÄÖµ,Select Choose(1,"a","b","c")·µ»Øa,½«1¸Ä³É2ºó£¬·µ»Øb,¸Ä³É3ºó£¬·µ»Øc(µÚÒ»¸ö²ÎÊýÒ²¿ÉÒÔÊÇij¸ö×Ö¶Î)
IIF ¸ù¾Ý±í´ïʽ·µ»ØÌض¨µÄÖµ Select IIF("3>1","OK","False")£¬·µ»ØOK
¡øSqlºÏ¼Æº¯Êý
Avg È¡×Ö¶Îƽ¾ùÖµ
Count ͳ¼Æ¼Ç¼ÌõÊý
Max È¡×Ö¶Î×î´óÖµ
Min È¡×Ö¶Î×îСֵ
StDev ¹ÀËãÑù±¾µÄ±ê×¼²î£¨ºöÂÔÑù±¾ÖеÄÂß¼Öµ
Ïà¹ØÎĵµ£º
ʹÓÃÁËTCP/IP£¬ADO¼°XML£¨ÐèÒª°²×°Microsoft XML 4.0¡££©¡£·Ö·þÎñÆ÷ºÍ¿Í»§¶ËÁ½²¿·Ö£¬·þÎñÆ÷¿ÉÒÔ¶àÓû§Í¬Ê±Á¬½Ó¡£Ô¶³ÌÁ¬½ÓAccessÊý¾Ý¿âÓкܶ෽·¨£¬ÎÒÒÔÇ°ÒѾ±È½Ï¾ßÌåµÄ»Ø´ð¹ý£¨¼ûÏÂÃæËùÁеÄ5ÖÖ·½·¨£©£¬ÎÒÏÖÔÚÕâ¸öÀý×ÓÊôÓÚÆäÖеĵڣ³ÖÖ·½·¨£¨²»ÐèҪʹÓÃRDS»òWeb·þÎñÆ÷£©¡£
Ô¶³ÌÁ¬½ÓaccessÊý¾Ý¿âµÄ¼¸¸ö·½·¨£º
£±£®½¨Á¢VPN ......
ÊìϤSQL SERVER 2000µÄÊý¾Ý¿â¹ÜÀíÔ±¶¼ÖªµÀ£¬ÆäDTS¿ÉÒÔ½øÐÐÊý¾ÝµÄµ¼Èëµ¼³ö£¬Æäʵ£¬ÎÒÃÇÒ²¿ÉÒÔʹÓÃTransact-SQLÓï¾ä½øÐе¼Èëµ¼³ö²Ù×÷¡£ÔÚTransact-SQLÓï¾äÖУ¬ÎÒÃÇÖ÷ҪʹÓÃOpenDataSourceº¯Êý¡¢OPENROWSET º¯Êý£¬¹ØÓÚº¯ÊýµÄÏêϸ˵Ã÷£¬Çë²Î¿¼SQLÁª»ú°ïÖú¡£ÀûÓÃÏÂÊö·½·¨£¬¿ÉÒÔÊ®·ÖÈÝÒ×µØʵÏÖSQL SERVER¡¢ACCESS¡¢EXCELÊý¾Ýת»»£ ......
ýÌå½ÓÈë¿ØÖƲãµÄËõд
ʲôÊÇmac!!!
Èç¹ûÄãÊÇͨ¹ýУ԰Íø»òСÇø½ÓÈëInternet£¬ÄÇôһ¶¨Ìý˵¹ýMACµØÖ·¡£Ê²Ã´ÊÇMACµØÖ·£¬MACµØÖ·ÔÚÕâÖÖ¾ÖÓòÍø»·¾³Öо¿¾¹Æðµ½Ê²Ã´×÷Óã¿ÏÂÃæ¾ÍÀ´½éÉÜÒ»ÏÂMACµØÖ·µÄ֪ʶ£¬MACµØÖ·ºÍIPµØÖ·µÄÇø±ðÒÔ¼°MACµØÖ·ÔÚʵ¼ÊÓ¦ÓÃÖÐËùÉæ¼°µ½µÄ°²È«ÎÊÌâ¡£
¡¡¡¡Ò»¡¢»ù´¡ÖªÊ¶
¡¡¡¡Èç½ñµÄÍøÂçÊÇ·Ö²ãÀ´Êµ ......
¼´Ê¹ÎÒ½«Êý¾Ý¿â·ÅÔÚÏîÄ¿ÄÚ½¨µÄÎļþ¼ÐdbÏ£¬¿ÉÊǽøÐд洢²Ù×÷µÄʱºò£¬Êý¾Ý±íûÓÐÈκα仯¡£ºóÀ´·¢ÏÖ´¢´æ¸Ä±ä·¢ÉúÔÚbin\\debug\\dbĿ¼ÏµÄÊý¾Ý¿âÖУ¬Õâ¸öÊý¾Ý¿âÊÇÔÚ³ÌÐòÔËÐÐʱ×Ô¶¯¸´ÖƹýÈ¥µÄ£¬¿ÉÊÇΪʲô´æ´¢±ä»¯Ã»Óз´Ó¦µ½ÍâÃæÏîÄ¿ÄÚµÄÊý¾Ý¿âdbÏÂÄØ£¿ÎÒÏëÁ¬½Ó×Ö·û´®ÖÐdatasourceÖеÄdatadirectory´æÔÚһЩÐþ»ú£¬ÓÚÊÇÎÒÕÒµ½Ò ......