insert into qty_rec(rec_time,account,account_group,group_name,opration,oprator,qty,auth_qty,remnant_qty,remark) values('10-01-26 04:44:24','zwwlmzy',1,'ϵͳ»ù±¾×é','ÐÞ¸ÄÊÚÐÅ', 'zwwlmzy','1200','1200','2000','ÊÚÐŽð¶î1200');
µÚÒ»¸ö×Ö¶ÎΪʱ¼äÀàÐÍ!
Êý¾Ý²åÈë³É¹¦ºó
rec_timeÕâ¸öµÄֵΪ0:00:00
Èç¹ûÎÒ°Ñ '10-01-26 04:44:24'¸ÄΪ now()
²åÈë³É¹¦ºó ʱ¼äÊÇ2010-1-26 8:43:23
¶øÎÒµçÄÔÉϵÄʱ¼äÈ·ÊÇ 2010-1-26 14:48:21
Çó¸ßÈËÖ¸µãÒ»ÏÂ!
insert into qty_rec(rec_time,account,account_group,group_name,opration,oprator,qty,auth_qty,remnant_qty,remark) values(#2010-01-26 04:44:24#,'zwwlmzy',1,'ϵͳ»ù±¾×é','ÐÞ¸ÄÊÚÐÅ', 'zwwlmzy','1200','1200','2000','ÊÚÐŽð¶î1200');
£Á£Ã£Ã£Å£Ó£ÓÖÐÈÕÆÚ³£Á¿ÒÔ££££À´±êʶ£¬ÁíÍ⽨Òé¼ÓÉÏ 2010ÒÔ·ÀÖ¹½âÎö´íÎó¡£
ʹÓÃnow()µÄʱºò ÎÒÔÚ±¾»úÔËÐÐ Êý¾ÝÔ´Ò²ÊDZ¾µØµÄ
¾ÓÈ»»¹ÓÐʱ¼ä²î ÎªÊ²Ã´ÄØ?
ÄãµÄ´úÂëÊÇʲô£¿Æ¾¿Õ´ó¼ÒÔõô²ÂÄØ£¿
ÔÚMSSQLÖУ¬ÎÒÃÇ¿ÉÒÔÒ»´Î²éѯ¶à¸öÊý¾Ý±í²¢¼ÓÈëµ½Êý¾Ý¼¯ÖУ¬ÖмäÖ»ÐèÓ÷ֺŸô¿ª£®È磺
£¢select * from A;select * from B;select * from C£¢,Ìî³äÊý¾Ý¼¯ºóÔÚDSÖоÍÓÐÁËÈýÕÅ±í£®
µ«ÔÚÓÃͬÑùµÄÓï¾ä·ÃÎÊACCESSÊý¾ ......
ÎÒ»ú×ÓÀïÃæÃ»ÓÐACCESS,ÇëÎÊÔÚ²»ÖØ×°ÏµÍ³µÄÇé¿öϸÃÈçºÎ°ÑËü×°ÉÏ,֮ǰÎÒÊÔ×°¹ýÆäËü°æ±¾µÄSP3 OFFICE,µ«»¹ÊÇ×°²»ÉÏ,
ÇëÎÊÓÐʲôºÃ°ì·¨Âð?
°²×°OFFICE £¬Ñ¡Ôñ°²×°ACCESS¾Í¿ÉÒÔѽ ¡£
ÒýÓÃ
°²×°OFFICE £¬Ñ¡Ôñ°²×° ......
ÓÐÒ»¸öÊý¾Ý¿âÀïÖ»ÓÐ2WÌõÊý¾Ý²»µ½£¬È´ÓÐ500MÄÇô´ó,Ôõô»ØÊ°¡£¿ÊÇACCESSµÄÊý¾Ý¿â¡£ºóÀ´ÎÒ°ÑACCESSµ¼Èëµ½MSSQLÖУ¬Ò²Õ¼ÓÃÁË500M×óÓҵĿռ䣬Èç¹ûѹËõÊý¾Ý¿âÄØ£¿Çë¸ßÊÖÖ¸µã
ѹËõÊý¾Ý¿â£¿ÄÜ×öµ½Ã´...
ÆÚ´ý¸ßÈËÖ¸µã ÎÒ ......