create table(access»·¾³ÏÂ)×Ô¶¯±àºÅÀàÐ͵Äд·¨
create table(access»·¾³ÏÂ)×Ô¶¯±àºÅÀàÐ͵Äд·¨
·½·¨Ò»£º
create table tablename(id counter constraint primarykey primary key)
ÐèҪעÒâµÄµØ·½ÊÇ:µÚ¶þ¸öprimaryÖмäÓпոñ,ÁíÍâ,¹Ø¼ü×Ö²»Çø·Ö´óСд.
·½·¨¶þ:
create table mytb (id autoincrement(25,1) primary key,age int)
»ò
create table testtb (id autoincrement,age int,email char, primary key (id))
ÆäÖÐÔÚaccessÖÐ,autoincrementΪ×Ô¶¯±àºÅÀàÐÍ×Ö¶Î,(25,1)·Ö±ðΪ³õʼֵ¼°²½³¤Öµ,Èç¹û²»Ð´µÄ»°,ĬÈÏÊÇ1,1,primary keyÖ¸¶¨ÁËÖ÷¼ü,ÒÔÉÏʾÀý,Á½ÖÖÖ¸¶¨·½·¨¶¼¿ÉÒÔ.
Ïà¹ØÎĵµ£º
OPENDATASOURCE ´ò¿ªexcel¡¢access¡¢qsl
use test
insert into OPENDATASOURCE('SQLOLEDB', 'Data Source=192.168.2.200;User ID=sa;Password=110').test.dbo.adf--´ò¿ªÔ¶³ÌÊý¾Ý¿â
select * from OpenRowSet('Microsoft.Jet.OLEDB.4.0', 'Excel 8.0;HDR=Yes;IMEX=1;Database=c:\2003.xls', [kg$])
--²éѯԶ³ÌÊý¾Ý ......
Ò»¡¢ADO¼ò½é
ADO(Active Data Object£¬»î¶¯Êý¾Ý¶ÔÏó)ʵ¼ÊÉÏÊÇÒ»ÖÖ»ùÓÚCOM(×é¼þ¶ÔÏóÄ£ÐÍ)ÖеÄ×Ô¶¯»¯½Ó¿Ú(IDispatch)¼¼Êõ£¬²¢ÒÔOLE DB(¶ÔÏóÁ¬½ÓºÍÏâÈëµÄÊý¾Ý¿â)Ϊ»ù´¡£¬¾¹ýOLE DB¾«Ðİü×°ºóµÄÊý¾Ý¿â·ÃÎʼ¼Êõ£¬ÀûÓÃËü¿ÉÒÔ¿ìËٵĴ´½¨Êý¾Ý¿âÓ¦ÓóÌÐò¡£
ADOÌṩÁËÒ»×é·Ç³£¼òµ¥£¬½«Ò»°ãͨÓõÄÊý¾Ý·ÃÎÊϸ½Ú½øÐзâ×°µÄ¶ÔÏó¡£ÓÉÓ ......
½ñÌì°ÑÒÔǰ×öµÄASPÍøÕ¾·Åµ½IISÀïÃæ¡¡Í»È»³öÏÖÊý¾Ý¿âÁ¬½Ó´íÎó¡¡Êä³öÀ´ÎªÎ´Ö¸¶¨´íÎó¡¡ÓôÃÆ£¡ÒÔǰ»¹ÊǺúõġ¡×Ô¼ºÑ§C££µÄ¡¡¶ÔASP²»ÊǷdz£Á˽⡡ÔÚÍøÉϲéÁËһϡ¡ÓÐÒø¶àÔÒò¡¡×î´óµÄ¿ÉÄÜÊÇÇý¶¯´íÎ󣬵«ÊÇÎÒÊÔÁËÎÒ×öµÄasp.neµÄÍøÕ¾ÔËÐеĺúõġ¡Ó¦¸Ã²»ÊÇÇý¶¯µÄÎÊÌâ¡¡ÕÒÁ˰ëÌìÖÕÓÚÕÒµ½Ò»¸öÐÞ¸ÄtempµÄȨÏÞ¡¡×îÖղŽâ¾ö¡¡
ÐÞ¸Ä ......
1.now() »ñÈ¡µ±Ç°Ê±¼ä£»
2.¹ØÓÚAccessÄÚ²¿µÄÄ£ºý²éѯ£º
ÔÚC#ÀïдӦд³É Select * from Table Where Name Like '%ABC%'
Select * from Table Where Name Like '_AB ......
×îºóÔÚһλ´óÏÀµÄBLOGÉÏ¿´µ½
ÓÒ»÷“ÎҵĵçÄÔ”¡£µ¥»÷“ÊôÐÔ”¡£
ÔړϵͳÊôÐÔ”Öе¥»÷“¸ß¼¶”¡£
ÔÚ“ÐÔÄÜ”Öе¥»÷“ÉèÖÔ¡£
ÔÚ“ÐÔÄÜÑ¡Ïî”Öе¥»÷“Êý¾ÝÖ´Ðб£»¤”¡£
µ¥»÷“Ìí¼Ó”¡£Ñ¡ÔñÒªÔËÐеijÌÐò¡£
OK¡£¾ÍÕâô¼òµ¥ ......