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
Ïà¹ØÎĵµ£º
create PROCEDURE pagelist
@tablename nvarchar(50),
@fieldname nvarchar(50)='*',
@pagesize int output,--ÿҳÏÔʾ¼Ç¼ÌõÊý
@currentpage int output,--µÚ¼¸Ò³
@orderid nvarchar(50),--Ö÷¼üÅÅÐò
@sort int,--ÅÅÐò·½Ê½£¬1±íʾÉýÐò£¬0±íʾ½µÐòÅÅÁÐ
......
Select CONVERT(varchar(100), GETDATE(), 0): 05 16 2006 10:57AM
Select CONVERT(varchar(100), GETDATE(), 1): 05/16/06
Select CONVERT(varchar(100), GETDATE(), 2): 06.05.16
Select CONVERT(varchar(100), GETDATE(), 3): 16/05/06
Select CONVERT(varchar(100), GETDATE(), 4): 16.05.06
Select CONVERT(varch ......
´æ´¢½ø³Ì¾ÍÊÇ×÷Ϊ¿ÉÖ´ÐжÔÏó´æ·ÅÔÚÊý¾Ý¿âÖеÄÒ»¸ö»ò¶à¸öSQLÃüÁî¡£
¶¨Òå×ÜÊǺܳéÏó¡£´æ´¢½ø³ÌÆäʵ¾ÍÊÇÄÜÍê³ÉÒ»¶¨²Ù×÷µÄÒ»×éSQLÓï¾ä£¬Ö»²»¹ýÕâ×éÓï¾äÊÇ·ÅÔÚÊý¾Ý¿âÖеÄ(ÕâÀïÎÒÃÇ̸ֻSQL SERVER)¡£Èç¹ûÎÒÃÇͨ¹ý´´½¨´æ´¢½ø³ÌÒÔ¼°ÔÚASPÖе÷Óô洢½ø³Ì£¬¾Í¿ÉÒÔ±ÜÃ⽫SQLÓï¾äͬASP´úÂë»ìÔÓÔÚÒ»Æð¡£ÕâÑù×öµÄºÃ´¦ÖÁÉÙÓÐÈý¸ö£º
µÚÒ»¡ ......
public class SqlCheck
{
public SqlCheck()
{
//
// TODO: ÔÚ´Ë´¦Ìí¼Ó¹¹Ô캯ÊýÂß¼
//
}
public SqlConnection oconn()
{
SqlConnection conn = new SqlConnection();
conn.ConnectionString = ConfigurationManager.ConnectionStrings["StudyConnectionString"] ......
ÔÚ×ö±¨±íʱoqlÓï¾äÖÐÓÐʱÐèÒªÓõ½Óû§×Ô¶¨Ò庯Êý£¬µ÷ÓÃÖ®ºó±¨±í±¨´í£º¡° ¶ÔÊý¾Ý¼¯¡°DataQuery¡±Ö´Ðвéѯʧ°Ü¡£ 'fn_GetLevelItemCatName' ²»ÊÇ¿ÉÒÔʶ±ðµÄ º¯ÊýÃû³Æ¡£ ')' ¸½½üÓÐÓï·¨´íÎó¡£ ¡° £¬ÓÚÊÇÎÒ½«oqlÓï¾ä½âÎöºóÄÃsqlÓï¾äµ½sql server 2008ÖÐÈ¥Ö´Ðб¨´í£º 'fn_GetLevelItemCatName' ²»ÊÇ¿ÉÒÔʶ±ðµÄº¯ÊýÃû³Æ¡£ ÕâÖÖÎÊÌ ......