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

sql server 2005 Êý¾ÝÀàÐÍ£¨²¿·Ö£©Ïêϸ˵Ã÷


 
      ÔÚ¼ÆËã»úÖÐÊý¾ÝÓÐÁ½ÖÖÌØÕ÷£ºÀàÐͺͳ¤¶È¡£ËùνÊý¾ÝÀàÐ;ÍÊÇÒÔÊý¾ÝµÄ±íÏÖ·½Ê½ºÍ´æ´¢·½Ê½À´»®·ÖµÄÊý¾ÝµÄÖÖÀà¡£ÔÚSQL Server ÖÐÿ¸ö±äÁ¿¡¢²ÎÊý¡¢±í´ïʽµÈ¶¼ÓÐÊý¾ÝÀàÐÍ¡£ ÆäÖУ¬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


Ïà¹ØÎĵµ£º

sql 2005 ´æ´¢¹ý³Ì·ÖÒ³ java ´úÂë

 create PROCEDURE pagelist
@tablename nvarchar(50),
@fieldname nvarchar(50)='*',         
@pagesize int output,--ÿҳÏÔʾ¼Ç¼ÌõÊý
@currentpage int output,--µÚ¼¸Ò³
@orderid nvarchar(50),--Ö÷¼üÅÅÐò
@sort int,--ÅÅÐò·½Ê½£¬1±íʾÉýÐò£¬0±íʾ½µÐòÅÅÁÐ ......

º½¿Õ¹«Ë¾¹ÜÀíϵͳ(VC++ ÓëSQL 2005)

ϵͳ»·¾³£ºWindows 7
Èí¼þ»·¾³£ºVisual C++ 2008 SP1 +SQL Server 2005
±¾´ÎÄ¿µÄ£º±àдһ¸öº½¿Õ¹ÜÀíϵͳ
      ÕâÊÇÊý¾Ý¿â¿Î³ÌÉè¼ÆµÄ³É¹û£¬ËäÈ»³É¼¨²»¼Ñ£¬µ«ÊÇ×÷ΪÎÒÓÃVC++ ÒÔÀ´±àдµÄ×î´ó³ÌÐò»¹ÊÇ´«µ½ÍøÉÏ£¬ÒÔ¹©²Î¿¼¡£ÓÃVC++ ×öÊý¾Ý¿âÉè¼Æ²¢²»ÈÝÒ×£¬µ«Ò²²»ÊDz»¿ÉÄÜ¡£ÒÔÏÂÊÇÎҵijÌÐò½çÃæ£¬ºóÃæ ......

SQL Server2005 °²×°·½·¨

  µÚÒ»´Î°²×°2005,»¨Á˲»ÉÙ¾«Á¦¡£ËäȻûʲô̫Äѵ쬵«ÊDz»ÖªµÀµÄ»°»áºÜ¼¬Êֵġ£Èç¹ûÄãÕýÔÚ°²×°£¬²¢ÇÒ·¢ÏÖÕâÆªÎÄÕ£¬ÄÇôÄãºÜ×ßÔË£¬Ä㽫»á˳ÀûµÄ°²×°³É¹¦¡£
    °²×°Ä¿Â¼Öаüº¬Sql Server x64  ºÍ x86,  x86ÊÇ32λ»úÆ÷µÄ¡£x86ÖÐÓÖÓÐtools ºÍ   Servers ¡£µÚÒ»´Î°²×°ÁËServers£¬È» ......

asp.netÈçºÎÁ¬½Ósql server2000Êý¾Ý¿â

¡ïAsp.netÈçºÎÁ¬½ÓSQL Server2000Êý¾Ý¿â¡ï
 
´ó¼ÒºÃ,ÒÔÏÂÊÇÓйØASP.netÁ¬½ÓSQL Server2000Êý¾Ý¿âµÄÀý³Ì£¬
ÔÚÕâÀïºÍ´ó¼Ò·ÖÏíһϣº
Asp.netÁ¬½ÓSQL Server2000Êý¾Ý¿âÀý³ÌÏê½â: 
<%@ Import Namespace="System.Data" %> 
<%@ Import NameSp ......

SQLɾ³ýÖ¸¶¨×Ö¶ÎÎÊÌâ

¸üÐÂÏÂÎÊÌ⣺
񡜧TBL_Info
×ֶΣº
    infoId int
    title  varchar(20)
    Content  text
    byUser  varchar(20)
    createTime datetime
1¡¢ÈçºÎɾ³ý±íÖÐÊý¾ÝÏàͬµÄÊý¾ÝÄØ£¿£¨Ö÷¼ü³ýÍ⣩
2¡¢ÈçºÎɾ³ýÊý¾Ý±íÖÐij¸ö×Ö¶ÎÊý¾ÝÏàÍ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ