SQL ServerÊý¾ÝÀàÐͽéÉÜ
ÔÚ¼ÆËã»úÖÐÊý¾ÝÓÐÁ½ÖÖÌØÕ÷£ºÀàÐͺͳ¤¶È¡£ËùνÊý¾ÝÀàÐ;ÍÊÇÒÔÊý¾ÝµÄ±íÏÖ·½Ê½ºÍ´æ´¢·½Ê½À´»®·ÖµÄÊý¾ÝµÄÖÖÀà¡£
ÔÚSQL Server ÖÐÿ¸ö±äÁ¿¡¢²ÎÊý¡¢±í´ïʽµÈ¶¼ÓÐÊý¾ÝÀàÐÍ¡£ÏµÍ³ÌṩµÄÊý¾ÝÀàÐÍ·ÖΪ¼¸´óÀ࣬Èç±í4-2 Ëùʾ¡£
ÆäÖУ¬BIGINT¡¢ SQL_VARIANT ºÍTABLE ÊÇSQL Server 2000 ÖÐÐÂÔö¼ÓµÄ3 ÖÖÊý¾ÝÀàÐÍ¡£ÏÂÃæ·ÖÀིÊö¸÷ÖÖÊý¾ÝÀàÐÍ¡£
Ò»¡¢ ÕûÊýÊý¾ÝÀàÐÍ
ÕûÊýÊý¾ÝÀàÐÍÊÇ×î³£ÓõÄÊý¾ÝÀàÐÍÖ®Ò»¡£
1¡¢INT £¨INTEGER£©
INT £¨»òINTEGER£©Êý¾ÝÀàÐÍ´æ´¢´Ó-2µÄ31´Î·½ £¨-2 £¬147 £¬483 £¬648£© µ½2µÄ31´Î·½-1 £¨2 £¬147
£¬483£¬647£© Ö®¼äµÄËùÓÐÕý¸ºÕûÊý¡£Ã¿¸öINT ÀàÐ͵ÄÊý¾Ý°´4 ¸ö×Ö½Ú´æ´¢£¬ÆäÖÐ1 λ±íʾÕûÊýÖµµÄÕý¸ººÅ£¬ÆäËü31
λ±íʾÕûÊýÖµµÄ³¤¶ÈºÍ´óС¡£
2¡¢SMALLINT
SMALLINT Êý¾ÝÀàÐÍ´æ´¢´Ó-2µÄ15´Î·½£¨ -32£¬ 768£© µ½2µÄ15´Î·½-1£¨ 32 £¬767 £©Ö®¼äµÄËùÓÐÕý¸ºÕûÊý¡£Ã¿¸öSMALLINT ÀàÐ͵ÄÊý¾ÝÕ¼ÓÃ2 ¸ö×ֽڵĴ洢¿Õ¼ä£¬ÆäÖÐ1 λ±íʾÕûÊýÖµµÄÕý¸ººÅ£¬ÆäËü15 λ±íʾÕûÊýÖµµÄ³¤¶ÈºÍ´óС¡£
3¡¢TINYINT
TINYINTÊý¾ÝÀàÐÍ´æ´¢´Ó0 µ½255 Ö®¼äµÄËùÓÐÕýÕûÊý¡£Ã¿¸öTINYINTÀàÐ͵ÄÊý¾ÝÕ¼ÓÃ1 ¸ö×ֽڵĴ洢¿Õ¼ä¡£
4¡¢BIGINT
BIGINT Êý¾ÝÀàÐÍ´æ´¢´Ó-2^63 £¨-9 £¬223£¬ 372£¬ 036£¬ 854£¬ 775£¬ 807£© µ½2^63-1£¨ 9£¬ 223£¬
372£¬ 036 £¬854 £¬775£¬ 807£© Ö®¼äµÄËùÓÐÕý¸ºÕûÊý¡£Ã¿¸öBIGINT ÀàÐ͵ÄÊý¾ÝÕ¼ÓÃ8¸ö×ֽڵĴ洢¿Õ¼ä¡£
¶þ¡¢ ¸¡µãÊý¾ÝÀàÐÍ
¸¡µãÊý¾ÝÀàÐÍÓÃÓڴ洢ʮ½øÖÆСÊý¡£¸¡µãÊýÖµµÄÊý¾ÝÔÚSQL Server ÖвÉÓÃÉÏÉáÈ루Round up
»ò³ÆΪֻÈë²»Éᣩ·½Ê½½øÐд洢¡£ËùνÉÏÉáÈëÊÇÖ¸£¬µ±£¨ÇÒ½öµ±£©ÒªÉáÈëµÄÊýÊÇÒ»¸ö·ÇÁãÊýʱ£¬¶ÔÆä±£ÁôÊý×Ö²¿·ÖµÄ×îµÍÓÐЧλÉϵÄÊýÖµ¼Ó1
£¬²¢½øÐбØÒªµÄ½øλ¡£ÈôÒ»¸öÊýÊÇÉÏÉáÈëÊý£¬Æä¾ø¶ÔÖµ²»»á¼õÉÙ¡£È磺¶Ô3.14159265358979 ·Ö±ð½øÐÐ2 λºÍ12λÉáÈ룬½á¹ûΪ3.15
ºÍ3.141592653590¡£
1¡¢REAL Êý¾ÝÀàÐÍ
REALÊý¾ÝÀàÐͿɾ«È·µ½µÚ7 λСÊý£¬Æ䷶ΧΪ´Ó-3.40E -38 µ½3.40E +38¡£ ÿ¸öREALÀàÐ͵ÄÊý¾ÝÕ¼ÓÃ4 ¸ö×ֽڵĴ洢¿Õ¼ä¡£
2¡¢FLOAT
FLOAT Êý¾ÝÀàÐͿɾ«È·µ½µÚ15 λСÊý£¬Æ䷶ΧΪ´Ó-1.79E -308 µ½1.79E +308¡£ ÿ¸öFLOAT ÀàÐ͵ÄÊý¾ÝÕ¼ÓÃ8
¸ö×ֽڵĴ洢¿Õ
Ïà¹ØÎĵµ£º
ת×ÔCSDNÂÛ̳£ºchaihuoniu
ÏÂÁÐÓï¾ä²¿·ÖÊÇMssqlÓï¾ä£¬²»¿ÉÒÔÔÚaccessÖÐʹÓá£
SQL·ÖÀࣺ
DDL—Êý¾Ý¶¨ÒåÓïÑÔ(CREATE£¬ALTER£¬DROP£¬DECLARE)
DML—Êý¾Ý²Ù×ÝÓïÑÔ(SELECT£¬DELETE£¬UPDATE£¬INSERT)
DCL—Êý¾Ý¿ØÖÆÓïÑÔ(GRANT£¬REVOKE£¬COMMIT£¬ROLLBACK)
Ê×ÏÈ,¼òÒª½éÉÜ»ù´¡Óï¾ä£º
1¡¢ËµÃ÷£º´´½¨Êý¾ ......
SQLÓï·¨ÊÖ²á
Select
ÓÃ;£º
´ÓÖ¸¶¨±íÖÐÈ¡³öÖ¸¶¨µÄÁеÄÊý¾Ý
Óï·¨£º
SELECT column_name(s) from table_name
½âÊÍ£º
´ÓÊý¾Ý¿âÖÐÑ¡È¡×ÊÁÏÁУ¬²¢ÔÊÐí´ÓÒ»»ò¶à¸ö×ÊÁϱíÖУ¬Ñ¡È¡Ò»»ò¶à¸ö×ÊÁÏÁлò×ÊÁÏÐС£SELECT ³ÂÊöʽµÄÍêÕûÓï·¨Ï൱¸´ÔÓ£¬µ«Ö÷Òª×Ó¾ä¿ÉժҪΪ£º
SELECT select_ ......
/**
* @author ºýÍ¿¹í
* ÔÚ½¨Á¢Á¬½Ó֮ǰÐèҪһЩ׼±¸¹¤×÷£º
* ÔÚ¿ØÖÆÃæ°åÉÏͨ¹ý“¹ÜÀí¹¤¾ß”µÄ“Êý¾ÝÔ´(ODBC)”´ò¿ª“ODBCÊý¾ÝÔ´¹ÜÀíÆ÷”¶Ô»°¿ò£¬
* µ¥»÷“ϵͳDSN”Ñ¡Ï£¬È»ºóµ¥»÷“Ìí¼Ó”°´Å¥£¬µÃµ½“´´½¨Êý¾ÝÔ´”¶Ô»°¿ò£¬
......
SQL> select * from dept where deptno=&tt;
Enter value for tt:20
DEPTNO DNAME LOC
------ -------------- -------------
10 ACCOUNTING NEW YORK
ÕâÑùÎÞÂÛÊäÈë¶àÉÙ´ÎttµÄÖµ£¬ÏµÍ³Ö»½¨Á¢Ò»¸öÖ´Ðмƻ®£¬Ì ......
Çé¾°Ò»£º
±íÖÐÊý¾Ý
name score
aaa 11
aaa 19
bbb 12
bbb 18
ccc 19
ddd 21
ÆÚÍû²éѯ½á¹ûÈçÏÂ
name score
aaa 30
bbb   ......