access ÈÕÆÚ select,insert ¸ñʽ
ʱ¼ä¸ñʽ£¿
±ðÄÃcoldatatime ºÍCTimeʲôµÄ˵Ê¡£¡£ËµµãÓÐÓõġ£¡£¡£ËùÓлý·ÖÏàËÍ
ʲôÎÊÌ⣿
format(#2009-1-1#,'yyyy-mm-dd')£¿
select #2009-1-1#
insert into table (mydate) values (#2009-09-21#);
Óû§×Ô¶¨ÒåÈÕÆÚ/ʱ¼ä¸ñʽ (Format º¯Êý)
ÏÂÃæ±í¸ñ±êʶһЩ¿ÉÓÃÀ´´´½¨Óû§×Ô¶¨ÒåÈÕÆÚ/ʱ¼ä¸ñʽµÄ×Ö·û£º
×Ö·û ˵Ã÷
(:) ʱ¼ä·Ö¸ô·û¡£ÔÚһЩÇøÓò£¬¿ÉÄÜÓÃÆäËû·ûºÅÀ´µ±Ê±¼ä·Ö¸ô·û¡£¸ñʽ»¯Ê±¼äֵʱ£¬Ê±¼ä·Ö¸ô·û¿ÉÒÔ·Ö¸ôʱ¡¢·Ö¡¢Ã롣ʱ¼ä·Ö¸ô·ûµÄÕæÕý×Ö·ûÔÚ¸ñʽÊä³öʱȡ¾öÓÚϵͳµÄÉèÖá£
(/) ÈÕÆÚ·Ö¸ô·û¡£ÔÚһЩÇøÓò£¬¿ÉÄÜÓÃÆäËû·ûºÅÀ´µ±ÈÕÆÚ·Ö¸ô·û¡£¸ñʽ»¯ÈÕÆÚÊýֵʱ£¬ÈÕÆÚ·Ö¸ô·û¿ÉÒÔ·Ö¸ôÄê¡¢Ô¡¢ÈÕ¡£ÈÕÆÚ·Ö¸ô·ûµÄÕæÕý×Ö·ûÔÚ¸ñʽÊä³öʱȡ¾öÓÚϵͳÉèÖá£
c ÒÔ ddddd À´ÏÔʾÈÕÆÚ²¢ÇÒÒÔ ttttt À´ÏÔʾʱ¼ä¡£Èç¹ûÏëÏÔʾµÄÊýÖµÎÞСÊý²¿·Ö£¬ÔòÖ»ÏÔʾÈÕÆÚ²¿·Ö£¬Èç¹ûÏëÏÔʾµÄÊýÖµÎÞÕûÊý²¿·Ö£¬ÔòÖ»ÏÔʾʱ¼ä²¿·Ö¡£
d ÒÔûÓÐÇ°µ¼ÁãµÄÊý×ÖÀ´ÏÔʾÈÕ (1 – 31)¡£
dd ÒÔÓÐÇ°µ¼ÁãµÄÊý×ÖÀ´ÏÔʾÈÕ (01 – 31)¡£
ddd ÒÔ¼òдÀ´±íʾÈÕ (Sun –Sat)¡£
dddd ÒÔÈ«³ÆÀ´±íʾÈÕ (Sunday –Saturday)¡£
ddddd ÒÔÍêÕûÈÕÆÚ±íʾ·¨ÏÔʾ£¨°üÀ¨Äê¡¢Ô¡¢ÈÕ£©£¬ÈÕÆÚµÄÏÔʾҪÒÀϵͳµÄ¶ÌÈÕÆÚ¸ñʽÉèÖöø¶¨¡£È±Ê¡µÄ¶ÌÈÕÆÚ¸ñʽΪ m/d/yy¡£
dddddd ÒÔÍêÕûÈÕÆÚ±íʾ·¨ÏÔʾÈÕÆÚϵÁÐÊý£¨°üÀ¨Äê¡¢Ô¡¢ÈÕ£©£¬ÈÕÆÚµÄÏÔʾҪÒÀϵͳʶ±ðµÄ³¤ÈÕÆÚ¸ñʽ¶ø¶¨¡£È±Ê¡µÄ³¤ÈÕÆÚ¸ñʽΪ mmmm dd, yyyy¡£
aaaa Óëdddd Ò»Ñù£¬ËüÖ»ÊǸÃ×Ö·û´®µÄ±¾µØ»¯°æ±¾¡£
w ½«Ò»ÖÜÖеÄÈÕÆÚÒÔÊýÖµ±íʾ£¨1 ±íÐÇÆÚÈÕ~ 7±íÐÇÆÚÁù£©¡£
ww ½«Ò»ÄêÖеÄÐ
Ïà¹ØÎÊ´ð£º
ÎÒµÄÊý¾Ý¿âÊǼòÌåsqlserver2000 ,ÎÒÏëÔÚ·±ÌåaccessÏÂÁ¬½Ó,ͨ¹ýodbcÊÇ¿ÉÒÔÁË,µ«ÔÚaccessϳöÏÖ´ò¿ªµÄ±íÈ«ÖÐ"#ÒÑɾ³ý"
²»ÖªµÀÒªÔõô²Ù×÷²Å¿ÉÒÔÓÃACCESS·±ÌåÁ¬½Ó¼òÌåsqlserver2000.лл!!!
´ó¼Ò¶¼ ......
ÄÄλ´ó¸çÓÐACCESSÊý¾Ý¿â °¡£¿
¸øСµÜÒ»¸ö£¡
°²×°OFFICEʱѡÔñ°²×°ACCESS
°²×°OFFICEʱѡÔñ°²×°ACCESS
°²×°°ì¹«Èí¼þ£¬Ñ¡Ôñ×Ô¶¨Òå°²×°£¬È»ºóÑ¡ÉÏACCESS¾Í¿ÉÒÔÁË
officeÍêÕ ......
accessÊý¾Ý¿â£¬Ö±½ÓʹÓà select ×ֶΠfrom ±í ¶ÁÈ¡Êý¾Ý
È»ºóÔÚÒ³ÃæÖÐʹÓÃRepeaterÀ´ÏÔʾ
ÕâÕűíÓÐ2000ÌõÊý¾Ý£¬ËùÒÔÒ³Ãæ´ò¿ªµÄºÜÂý
Çë½Ì¸÷λÅóÓÑ£¬ÓÐûÓа취½â¾ö£¬Ìá¸ßµãËٶȣ¡
Ò»´ÎÈ«²¿¶ÁÍê ......
ΪʲôÊä³ö½á¹ûÊÇÕâÑùÄØ£¿
%@ Page Language="VB" AutoEventWireup="false" aspcompat="true" CodeFile="Default.aspx.vb" Inherits="_Default" % ......
ÎÒÔÚÄ£¿éÀï×Ô¶¨ÒåÁËÒ»¸öº¯Êý:stradd()
¿ÉÊÇÔÚadoquery1.sql.add('select stradd(author) from book');
ʱÌáʾstradd䶨Òå...
Õâ¸öÎÊÌâÓÐʲô°ì·¨¿ÉÒÔ½â¾öµÄÂð? ·Ç³£¸Ð¼¤!
......