AccessÓëSqlServerÊý¾ÝÀàÐͱȽÏ,timestampʱ¼ä´ÁÏê½â
Ò»¡¢AccessÓëSqlServerÊý¾ÝÀàÐÍ±È½Ï Microsoft Access Êý¾ÝÀàÐÍ SQL Server Êý¾ÝÀàÐÍ ÊÇ/·ñ£¬£¨0ºÍ-1£©
1 룬²»ÔÊÐíÓÐ Null Öµ¡£ bit(1¡¢0 »ò NULL) Êý×Ö£¨×Ö½Ú£©£¨0~255£©
1¸ö×Ö½Ú£¬ÎÞСÊýλ tinyint£¨0~255£©
´óСΪ 1 ×Ö½Ú Êý×Ö£¨ÕûÐÍ£©£¨-32768~32767£©
2 ¸ö×Ö½Ú, ÎÞСÊýλ smallint£¨-32768~32767£©
´óСΪ 2 ¸ö×Ö½Ú Êý×Ö£¨³¤ÕûÐÍ£©£¨-2,147,483,648~2,147,483,647£©
ĬÈÏÖµ£¬4¸ö×Ö½Ú£¬ÎÞСÊýλ int £¨-2^31 (-2,147,483,648) ~ 2^31 - 1 (2,147,483,647)£©
´æ´¢´óСΪ 4 ¸ö×Ö½Ú¡£int µÄ SQL-92 ͬÒå×ÖΪ integer Êý×Ö£¨µ¥¾«¶È¸¡µãÐÍ£©
¸ºÖµ:3.402823E38 ~ -1.401298E-45
ÕýÖµ:1.401298E-45 µ½ 3.402823E38
4 ¸ö×Ö½Ú,7λСÊý real £¨3.40E + 38 ~ 3.40E + 38£¬¸¡µãÊý×ÖÊý¾Ý£©
´æ´¢´óСΪ 4 ×Ö½Ú£¬Í¬Òå´ÊΪ float(24) £¨Î޵ȼ۵ÄÊý¾ÝÀàÐÍ£© bigint£¨-2^63 (-9,223,372,036,854,775,808)
~ 2^63-1 (9,223,372,036,854,775,807)£©
´æ´¢´óСΪ 8 ¸ö×Ö½Ú Êý×Ö£¨Ë«¾«¶È¸¡µãÐÍ£©
¸ºÖµ:
–1.79769313486231E308 ~–4.94065645841247E–324
ÕýÖµ:
4.94065645841247E–324~1.79769313486231E308
8 ¸ö×Ö½Ú, 15λСÊýλ float (n)£¨1.79E + 308 ~ 1.79E + 308£©£¬
n ±ØÐëΪ´Ó 1 µ½ 53 Ö®¼äµÄÖµ »õ±Ò
8 ¸ö×Ö½Ú
»õ±ÒÖµ»òÓÃÓÚÊýѧ¼ÆËãµÄÊýÖµÊý¾Ý£¬ÕâÀïµÄÊýѧ¼ÆËãµÄ¶ÔÏóÊÇ´øÓÐ 1 µ½ 4 λСÊýµÄÊý¾Ý¡£¾«È·µ½Ð¡Êýµã×ó±ß 15 λºÍСÊýµãÓÒ±ß 4 λ¡£ (1)¡¢money£¨-2^63 (-922,337,203,685,477.5808)
~ 2^63
Ïà¹ØÎĵµ£º
ÏÂÃæÊÇÎÒÔÚSQLServerÖÐÓõıȽ϶àµÄº¯Êý£¬Ä㻹ÓÃЩʲôº¯Êý£¿»òÕ߶ÔÄĸöº¯ÊýÓбȽϺÃÓ÷¨£¿»òÕßÄã²»ÓÃÄÄЩº¯Êý£¿
LEFT ( character_expression , integer_expression )
·µ»Ø´Ó×Ö·û´®×ó±ß¿ªÊ¼Ö¸¶¨¸öÊýµÄ×Ö·û¡£
Àý:
select left('my name is viwo',4)
my n
RIGHT ( character_expression , integer_expression )
·µ» ......
BOOL GetAllTables(LPCTSTR databasefile,CStringArray & dbtables)
{
//#import "msado15.dll" no_namespace rename("EOF", "adoEOF") //¿½±´ msado15.dll µ½¹¤³ÌĿ¼
_Conn ......
MS SQL Server²éѯÓÅ»¯·½·¨
²éѯËÙ¶ÈÂýµÄÔÒòºÜ¶à£¬³£¼ûÈçϼ¸ÖÖ
1¡¢Ã»ÓÐË÷Òý»òÕßûÓÐÓõ½Ë÷Òý(ÕâÊDzéѯÂý×î³£¼ûµÄÎÊÌ⣬ÊdzÌÐòÉè¼ÆµÄȱÏÝ)
2¡¢I/OÍÌÍÂÁ¿Ð¡£¬ÐγÉÁËÆ¿¾±Ð§Ó¦¡£
& ......
ADOÖÐsqlserver´æ´¢¹ý³ÌʹÓà ÊÕ²Ø
´ÓADOÖеõ½¶à¸ö¼Ç¼¼¯ÒÔ¼°ÔõôÑùÔÚADOÖÐʹÓÃsql server µÄ´æ´¢¹ý³Ì
DataType Value Length Data Length
BIGINT 996857543543543 15 8
INT 543543 6 4
SMALLINT 32765 5 2
TINYINT 254 3 1
BIT True 1 1
DECIMAL 765.5432321 11 9
NUMERIC 432.6544 8 5
MONEY 543.1234 ......
1£©Ð½¨Êý¾Ý¿âRESTORE
2£©ÔÚ¸ÃÊý¾Ý¿âÉÏÑ¡Ôñ£ºÈÎÎñ->»¹Ô->Êý¾Ý¿â
3£©ÔÚ»¹ÔÊý¾Ý¿â-RESTOREµÄ¶Ô»°¿òÖÐ
Ä¿±êÊý¾Ý¿âÊÇRESTORE
Ö¸¶¨ÓÃÓÚ»¹ÔµÄ±¸·Ý¼¯µÄÔ´ºÍλÖÃ->Ô´É豸->Ñ¡Ôñ×îºóÒ»¸öÍêÈ«µÄ±¸·ÝBAKÎļþ
¹´Öл¹ÔCheckBox
4£©Ñ¡Ôñ×óÉϽǵÄÑ¡Ïî
ÔÚ»¹ÔÑ ......