SQL Server 2008 R2——Data Types

The precision, scale, and length of the result depend on the precision, scale, and length of the input expressions. For more information, see Precision, Scale, and Length (Transact-SQL).

SQL Server provides data type synonyms for ISO compatibility. For more information, see Data Type Synonyms (Transact-SQL).

Data Type Categories

 

Data types in SQL Server are organized into the following categories:

 

Exact numerics

Unicode character strings

Approximate numerics

Binary strings

Date and time

Other data types

Character strings

 

In SQL Server, based on their storage characteristics, some data types are designated as belonging to the following groups:

Large value data types:  varchar(max),  nvarchar(max), and  varbinary(max)

Large object data types:  text,  ntext,  image,  varchar(max),  nvarchar(max),  varbinary(max), and  xml

Note

sp_help returns -1 as the length for the large-value and  xml data types.

Exact Numerics

 

bigint

numeric

bit

smallint

decimal

smallmoney

int

tinyint

money

 

Approximate Numerics

 

float

real

Date and Time

 

date

datetimeoffset

datetime2

smalldatetime

datetime

time

Character Strings

 

char

varchar

text

 

Unicode Character Strings

 

nchar

nvarchar

ntext

 

Binary Strings

 

binary

varbinary

image

 

Other Data Types

 

cursor

timestamp

hierarchyid

uniqueidentifier

sql_variant

xml

table

     

SQL Server 2008 R2——Data Types

标签：

查看更多关于SQL Server 2008 R2——Data Types的详细内容...