ÔÚAccessÖÐÌõ¼þ×Ö¶ÎΪÈÕÆÚÀàÐ͵IJéѯÓï¾äÎÊÌ⣡£¡
SELECT * from Test where Create_Date = '2009-01-01' ¾ÍÊÇÉÏÃæÕâÌõ²éѯÓï¾ä£¬ÔÚÖ´ÐÐÊÇACCESS±¨´í£¬Ìáʾ¡°±ê×¼±í´ïʽÖÐÊý¾ÝÀàÐͲ»Æ¥Å䡱£¬ÕâÊÇʲôÎÊÌâ°¡£¬ÔÚmssqlÖж¼¿ÉÒÔÕâÑùµÄ°¡£¡£¡ ²»ÖªµÀÎÊÌâÔÚÄÄÀÔÚÏֵȴó¼ÒµÄ½â¾ö°ì·¨£¬Ð»Ð»£¡£¡
creat_dateÊÇDateTimeÀàÐÍ?ÒýÓà creat_dateÊÇDateTimeÀàÐÍ? ²»ÒªÒâ˼£¬ËµÂ©ÁË£¬Create_date×Ö¶ÎʱDataTimeÀàÐÍ¡£ {{
Ïà¹ØÎÊ´ð£º
ÔÚMSSQLÖУ¬ÎÒÃÇ¿ÉÒÔÒ»´Î²éѯ¶à¸öÊý¾Ý±í²¢¼ÓÈëµ½Êý¾Ý¼¯ÖУ¬ÖмäÖ»ÐèÓ÷ֺŸô¿ª£®È磺 £¢select * from A;select * from B;select * from C£¢,Ìî³äÊý¾Ý¼¯ºóÔÚDSÖоÍÓÐÁËÈýÕÅ±í£® µ«ÔÚÓÃͬÑùµÄÓï¾ä·ÃÎÊACCESSÊý¾ ......
ÇëÎʸ÷λ´óʦ£¬ÎÒÏÖÔÚÐèÒª½«XMLµÄÊý¾ÝʵʱµÄ´æÈëµ½Êý¾Ý¿âÖУ¬ÎÒÊÇÓÃasp±àµÄ³ÌÐò£¬´óÁ¿Ãǰïæ·ÖÎö һϣ¡£¡£¡ ÏÂÃæÊÇÎÒµÄXMLÎļþ´úÂë XML code: <?xml version="1.0" encoding="utf-8"? ......
accessÖеÄtextÐ͵ÄÊý×Ö£¬Ôõô±È½Ï´óС°¡£¿ ´ó¼ÒÖªµÀÂð? ÒòΪÎÒÏë¸ù¾ÝÕâÒ»ÁÐÊý¾ÝµÄ´óС²éѯһЩ¶«Î÷ ¾Ù¸öÀý×Ó£º ¾ÍÊÇ£¬ÎÒÓÐÒ»ÁÐÊý¾ÝΪ±àÂ룺 ÊÇtextÐ͵ÄÊý×Ö£ºÈç 1101 1102 1103 µÈ£¬ ÎÒÏÖÔÚҪȡ³ö±àÂë±È ......
ÓÐÒ»¸öÊý¾Ý¿âÀïÖ»ÓÐ2WÌõÊý¾Ý²»µ½£¬È´ÓÐ500MÄÇô´ó,Ôõô»ØÊ°¡£¿ÊÇACCESSµÄÊý¾Ý¿â¡£ºóÀ´ÎÒ°ÑACCESSµ¼Èëµ½MSSQLÖУ¬Ò²Õ¼ÓÃÁË500M×óÓҵĿռ䣬Èç¹ûѹËõÊý¾Ý¿âÄØ£¿Çë¸ßÊÖÖ¸µã ѹËõÊý¾Ý¿â£¿ÄÜ×öµ½Ã´... ÆÚ´ý¸ßÈËÖ¸µã ÎÒ ......
֮ǰÓÃACCESS×öµÄÒ»¸öϵͳ£¬ÏÖÔÚ½«±í¶¼×ªµ½SQLÀȻºóÓÃODBCÁ¬½ÓSQL±í¡£ ÏÖÔÚÓиöÎÊÌâ¾ÍÊÇ£¬ÎÒÆäÖÐÓÐÒ»¸ö±íµÄÊý¾ÝÊÇ´ÓEXCELÀïµ¼ÈëµÄ£¬Èç¹û±íÔÚACCESS±¾µØµ¼ÈëÕý³££¬ÏÖÔÚÓÃÁ´½Ó±íµ½SQL£¬µ¼ÈëʱÌáʾ³É¹¦£¬µ«±íÄÚÎÞÊý ......