AccessÊý¾Ý¿â×Ö¶ÎÀàÐÍ˵Ã÷ÒÔ¼°ÓëSQLÖ®¼äµÄ¶ÔÕÕ¹Øϵ
Îı¾ nvarchar(n)
±¸×¢ ntext
Êý×Ö(³¤ÕûÐÍ) int
Êý×Ö(ÕûÐÍ) smallint
Êý×Ö(µ¥¾«¶È) real
Êý×Ö(Ë«¾«¶È) float
Êý×Ö(×Ö½Ú) tinyint
»õ±Ò money
ÈÕÆÚ smalldatetime
²¼¶û bit
¸½£º×ª»»³ÉSQLµÄ½Å±¾¡£
ALTER TABLE tb ALTER COLUMN aa Byte Êý×Ö[×Ö½Ú]
ALTER TABLE tb ALTER COLUMN aa Long Êý×Ö[³¤ÕûÐÍ]
ALTER TABLE tb ALTER COLUMN aa Short Êý×Ö[ÕûÐÍ]
ALTER TABLE tb ALTER COLUMN aa Single Êý×Ö[µ¥¾«¶È
ALTER TABLE tb ALTER COLUMN aa Double Êý×Ö[Ë«¾«¶È]
ALTER TABLE tb ALTER COLUMN aa Currency »õ±Ò
ALTER TABLE tb ALTER COLUMN aa Char Îı¾
ALTER TABLE tb ALTER COLUMN aa Text(n) Îı¾£¬ÆäÖÐn±íʾ×ֶδóС
ALTER TABLE tb ALTER COLUMN aa Binary ¶þ½øÖÆ
ALTER TABLE tb ALTER COLUMN aa Counter ×Ô¶¯±àºÅ
ALTER TABLE tb ALTER COLUMN aa Memo ±¸×¢
ALTER TABLE tb ALTER COLUMN aa Time ÈÕÆÚ/ʱ¼ä
ÔÚ±íµÄÉè¼ÆÊÓͼÖУ¬Ã¿Ò»¸ö×ֶζ¼ÓÐÉè¼ÆÀàÐÍ£¬AccessÔÊÐí¾ÅÖÖÊý¾ÝÀàÐÍ£ºÎı¾¡¢±¸×¢¡¢ÊýÖµ¡¢ÈÕÆÚ/ʱ¼ä¡¢»õ
±Ò¡¢×Ô¶¯±àºÅ¡¢ÊÇ/·ñ¡¢OLE¶ÔÏó¡¢³¬¼¶Á´½Ó¡¢²éѯÏòµ¼¡£
¡¡Îı¾£ºÕâÖÖÀàÐÍÔÊÐí×î´ó255¸ö×Ö·û»òÊý×Ö£¬AccessĬÈϵĴóСÊÇ50¸ö×Ö·û£¬¶øÇÒϵͳֻ±£´æÊäÈëµ½×Ö¶ÎÖеÄ
×Ö·û£¬¶ø²»±£´æÎı¾×Ö¶ÎÖÐδÓÃλÖÃÉϵĿÕ×Ö·û¡£¿ÉÒÔÉèÖÓ×ֶδóС”ÊôÐÔ¿ØÖÆ¿ÉÊäÈëµÄ×î´ó×Ö·û³¤¶È¡£
¡¡±¸×¢£ºÕâÖÖÀàÐÍÓÃÀ´±£´æ³¤¶È½Ï³¤µÄÎı¾¼°Êý×Ö£¬ËüÔÊÐí×Ö¶ÎÄܹ»´æ´¢³¤´ï64000¸ö×Ö·ûµÄÄÚÈÝ¡£µ«Access²»
ÄܶԱ¸×¢×ֶνøÐÐÅÅÐò»òË÷Òý£¬È´¿ÉÒÔ¶ÔÎı¾×ֶνøÐÐÅÅÐòºÍË÷Òý¡£ÔÚ±¸×¢×Ö¶ÎÖÐËäÈ»¿ÉÒÔËÑË÷Îı¾£¬µ«È´²»Èç
ÔÚÓÐË÷ÒýµÄÎı¾×Ö¶ÎÖÐËÑË÷µÃ¿ì¡£
¡¡Êý×Ö£ºÕâÖÖ×Ö¶ÎÀàÐÍ¿ÉÒÔÓÃÀ´´æ´¢½øÐÐËãÊõ¼ÆËãµÄÊý×ÖÊý¾Ý£¬Óû§»¹¿ÉÒÔÉèÖÓ×ֶδóС”ÊôÐÔ¶¨ÒåÒ»¸öÌض¨
µÄÊý×ÖÀàÐÍ£¬ÈκÎÖ¸¶¨ÎªÊý×ÖÊý¾ÝÀàÐ͵Ä×ÖÐÍ¿ÉÒÔÉèÖóɓ×Ö½Ú”¡¢“ÕûÊý”¡¢“³¤ÕûÊý”¡¢“µ¥¾«¶ÈÊý”¡¢
“Ë«¾«¶ÈÊý”¡¢“ͬ²½¸´ÖÆID”¡¢“СÊý”ÎåÖÖÀàÐÍ¡£ÔÚAccessÖÐͨ³£Ä¬ÈÏΪ“Ë«¾«¶ÈÊý”¡£
ÈÕÆÚ/ʱ¼ä£ºÕâÖÖÀàÐÍÊÇÓÃÀ´´æ´¢ÈÕÆÚ¡¢Ê±¼ä»òÈÕÆÚʱ¼äÒ»ÆðµÄ£¬Ã¿¸öÈÕÆÚ/ʱ¼ä×Ö¶ÎÐèÒª8¸ö×Ö½ÚÀ´´æ´¢¿Õ¼ä¡£
¡¡»õ±Ò£ºÕâÖÖÀàÐÍÊÇÊý×ÖÊý¾ÝÀàÐ͵ÄÌØÊâÀàÐÍ£¬µÈ¼ÛÓÚ¾ßÓÐË«¾«¶ÈÊôÐÔµÄÊý×Ö×Ö¶ÎÀàÐÍ¡£Ïò»õ±Ò×Ö¶ÎÊäÈëÊý¾Ý
ʱ£¬²»±Ø¼üÈëÈËÃñ±Ò·ûºÅºÍǧλ´¦µÄ¶ººÅ£¬Access»á×Ô¶¯ÏÔÊ
Ïà¹ØÎĵµ£º
Èí¼þÃû³Æ: EA2A(Excel/Access to Access)
Èí¼þ°æ±¾: beta2
ÊÚȨÐÎʽ: Ãâ·ÑÈí¼þ
ÔËÐÐƽ̨: Win9x/Me/NT/2000/XP/2003
Êý¾Ý¿âÉý¼¶ºóÔÓбíÖÐ×ֶλáÔö¼Ó£¬´ËʱÎÒÃǾÍÐèÒªµ¼È루ǨÒÆ£©Êý¾Ý£¬´Ë³ÌÐòΪʵÏִ˹¦Äܶø±àд¡£
ͨ³£Èí¼þÉý¼¶ºó£¬Êý¾Ý¿âÒ²»áÓÐËù¸Ä±ä£¬´Ëʱ¾ÍÐèÒª¶Ô¿Í»§Ê¹ÓõÄÊý¾Ý¿â½øÐÐÉý¼¶¡£Éý¼¶¿Í»§Êý¾Ý¿âµÄ·½Ê½Ó ......
http://www.umgr.com/blog/PostView.aspx?bpId=36294
1. Ö´ÐÐsqlÓï¾ä
int sqlite3_exec(sqlite3*£¬ const char *sql£¬ sqlite3_callbacksql Óï·¨
£¬ void *£¬ char **errmsg );
Õâ¾ÍÊÇÖ´ÐÐÒ»Ìõ sql Óï¾äµÄº¯Êý¡£
µÚ1¸ö²ÎÊý²»ÔÙ˵ÁË£¬ÊÇÇ°Ãæopenº¯ÊýµÃµ½µÄÖ¸Õ롣˵ÁËÊǹؼüÊý¾Ý½á¹¹¡£
µÚ2¸ö²ÎÊýconst char ......
1.Ñ¡Ôñ×îÓÐЧÂʵıíÃû˳Ðò(Ö»ÔÚ»ùÓÚ¹æÔòµÄÓÅ»¯Æ÷ÖÐÓÐЧ)¡¡¡¡
¡¡¡¡ SQLSERVERµÄ½âÎöÆ÷°´ÕÕ´ÓÓÒµ½×óµÄ˳Ðò´¦Àífrom×Ó¾äÖеıíÃû£¬Òò´Ëfrom×Ó¾äÖÐдÔÚ×îºóµÄ±í£¨»ù´¡±ídriving table£©½«±»×îÏÈ´¦Àí£¬ÔÚfrom×Ó¾äÖаüº¬¶à¸ö±íµÄÇé¿öÏ£¬±ØÐëÑ¡Ôñ¼Ç¼ÌõÊý×îÉٵıí×÷Ϊ»ù´¡±í£¬µ±SQLSERVER´¦Àí¶à¸ö±íʱ£¬»áÔËÓÃÅÅÐò¼°ºÏ²¢µÄ·½Ê½Á ......
1¡¢½Ø¶ÏÈÕÖ¾£º
backup log Êý¾Ý¿â with no_log
»ò£º
Çå¿ÕÈÕÖ¾
DUMP TRANSACTION ¿âÃû WITH NO_LOG
2¡¢ & ......
Use equality first.
ʹÓõÈÁ¬½Ó
Use range operators only where equality does not apply.
Ö»ÓÐÔÚµÈÁ¬½Ó²»¿ÉÓõÄÇé¿öÏÂÊÂÓÉÇø¼äÁ¬½Ó
Avoid use of negatives in the form of !=
or NOT.
±ÜÃâʹÓà £¡= »òÕß not
Avoid LIKE pattern matching.
±ÜÃâʹÓà LIKEÆ¥Åä
Try to retrieve specific rows and in small n ......