ÔÚAccessÖÐÌõ¼þ×Ö¶ÎΪÈÕÆÚÀàÐ͵IJéѯÓï¾äÎÊÌ⣡£¡
SELECT * from Test where Create_Date = '2009-01-01'
¾ÍÊÇÉÏÃæÕâÌõ²éѯÓï¾ä£¬ÔÚÖ´ÐÐÊÇACCESS±¨´í£¬Ìáʾ¡°±ê×¼±í´ïʽÖÐÊý¾ÝÀàÐͲ»Æ¥Å䡱£¬ÕâÊÇʲôÎÊÌâ°¡£¬ÔÚmssqlÖж¼¿ÉÒÔÕâÑùµÄ°¡£¡£¡ ²»ÖªµÀÎÊÌâÔÚÄÄÀÔÚÏֵȴó¼ÒµÄ½â¾ö°ì·¨£¬Ð»Ð»£¡£¡
creat_dateÊÇDateTimeÀàÐÍ?
²»ÒªÒâ˼£¬ËµÂ©ÁË£¬Create_date×Ö¶ÎʱDataTimeÀàÐÍ¡£
{{
Ïà¹ØÎÊ´ð£º
ÇëÎʸ÷λ´óʦ£¬ÎÒÏÖÔÚÐèÒª½«XMLµÄÊý¾ÝʵʱµÄ´æÈëµ½Êý¾Ý¿âÖУ¬ÎÒÊÇÓÃasp±àµÄ³ÌÐò£¬´óÁ¿Ãǰïæ·ÖÎö һϣ¡£¡£¡
ÏÂÃæÊÇÎÒµÄXMLÎļþ´úÂë
XML code:
<?xml version="1.0" encoding="utf-8"? ......
CREATE TABLE Product(model integer,
maker varchar(20),
CONSTRAINT SAND PRIMARY KEY (model),
CONSTRAINT PANDA FOREIGN KEY (model) REFERENCES PC (model)
ON DELETE CASCADE ......
ÈçºÎÐÞ¸Ämsysobjects±íÖеÄÊý¾ÝÄØ£¿Ð»Ð»
ɶ¶¼Ã»ÓÐ,Òâ˼²»Ã÷È·,ÔÙÏêϸµã°É
²»Òª¸ÄsysobjectsÀïµÄ¶«Î÷¡£
ÓÃÆäËü·½·¨¸Ä£¬±íÃû»òÆäËû¡£
ÒªÔÚACCESS»·¾³ÏÂÅäÖÃȨÏÞ£¬²ÅÄÜ·ÃÎÊϵͳ±í...
лл´ó¼Ò¡£
ÊÇÕâÑù£¬¿´ ......
ÎÒÔÚÇ°Ì¨Ò³ÃæÊäÈë¿òÊäÈë 20091208 µã»÷Ìá½»Ö®ºó±¨´í,˵ÀàÐͲ»Æ¥Åä.
Êý¾Ý¿âÀï Õâ¸ö×ֶεĸñʽӦ¸ÃÊÇ 2009-12-8 14:27:40
ÊDz»ÊÇÒª°Ñ 20091208 ת»»³É¸ñʽ 2009-12-8 14:27:40
ÇëÎÊÎ ......
accessÖеÄtextÐ͵ÄÊý×Ö£¬Ôõô±È½Ï´óС°¡£¿
´ó¼ÒÖªµÀÂð?
ÒòΪÎÒÏë¸ù¾ÝÕâÒ»ÁÐÊý¾ÝµÄ´óС²éѯһЩ¶«Î÷
¾Ù¸öÀý×Ó£º
¾ÍÊÇ£¬ÎÒÓÐÒ»ÁÐÊý¾ÝΪ±àÂ룺
ÊÇtextÐ͵ÄÊý×Ö£ºÈç
1101
1102
1103
µÈ£¬
ÎÒÏÖÔÚҪȡ³ö±àÂë±È ......