Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

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ÖÐÓõıȽ϶àµÄº¯Êý

ÏÂÃæÊÇÎÒÔÚSQLServerÖÐÓõıȽ϶àµÄº¯Êý£¬Ä㻹ÓÃЩʲôº¯Êý£¿»òÕß¶ÔÄĸöº¯ÊýÓбȽϺÃÓ÷¨£¿»òÕßÄã²»ÓÃÄÄЩº¯Êý£¿
LEFT ( character_expression , integer_expression )
·µ»Ø´Ó×Ö·û´®×ó±ß¿ªÊ¼Ö¸¶¨¸öÊýµÄ×Ö·û¡£
Àý:
select left('my name is viwo',4)
my n
RIGHT ( character_expression , integer_expression )
·µ» ......

SqlServerÖÐÐбäÁÐ

     ÀýÈç´´½¨Ò»¸ö±í
                 create table stz
              (
          &n ......

ADO ACCESS »ñÈ¡±íÃû

BOOL GetAllTables(LPCTSTR databasefile,CStringArray & dbtables)
    {
       //#import "msado15.dll" no_namespace rename("EOF", "adoEOF")   //¿½±´ msado15.dll µ½¹¤³ÌĿ¼
       _Conn ......

AccessµÄ×ªÒÆ×Ö·û

AccessÖÐÊý¾Ý¿âתÒå×Ö·û¹æÔò£º
 
²åÈë¡¢¸üС¢=Æ¥Åä Êý¾Ýʱ£¬Îı¾ÀàÐÍÈçÓÃ''À¨ÆðÀ´£¬Öмä¿ÉÒÔÓÐ ",*,%,[,],\,/,?,(,),{,}µÄÈÎÒâ×éºÏ£¬ÈçÒª²åÈëÒ»¸ö',Ðèд''²¢ÔÚÕû¸ö±í´ïʽÍâÌ×Ò»¶Ô''
È磬²åÈë 'ÕÅ''Èý',Êý¾Ý¿âÀï¾ÍÊÇ ÕÅ'Èý£¬Ó÷½À¨ºÅÊDz»¿ÉÒÔµÄ
 
²åÈë¡¢¸üС¢=Æ¥Åä Êý¾Ýʱ£¬Îı¾ÀàÐÍÈçÓÃ""À¨ÆðÀ´£¬Öмä¿ÉÒÔ ......

´¿JSP·ÖÒ³´úÂëÖ®sqlserver2005/2008

ÉÏһƪ·ÖÒ³ÎÄÕ£¬ÊÇÓÃÓÚmysql£¬ÉÔ΢ÐÞ¸ÄÏ£¬ÓÃÓÚSqlserver2005/2008£¬Ã»ÓÐÒì³£´¦Àí¡£Ã»Óп¼ÂÇÐÔÄܵȡ£
ÏÖ½«´úÂëÌù³ö£¬ÒÔ¹©³õѧÕ߲ο¼£º
×¢£ºÑûÔÂʹÓû·¾³Eclipse 3.4.2+Tomcat 6.18+Sqlserver2005 sp3µ÷ÊԳɹ¦¡£
Ò³ÃæpagelistDemo.jspÄÚÈÝ£º
Code
<%@ page language="java" contentType="text/html; ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ