SQL Server Facets-data types

SQL Server changes blob-related data types starting with 2005, such as text and ntext to varchar (max) and nvarchar (max), and image to varbinary (max). 2008 continues to add some new time-and date-related data types, as well as special data types that work with hierarchical data.

Data Type Overview

　　The data types in SQL Server are summarized in the following categories:

exact numbers	unicode string
approximate number	binary string
date and time	Other data types
String	?

Exact numbers

bigint	numeric
bit	smallint
decimal	smallmoney
int	tinyint
Money	??

Approximate numbers

Float

Real

Date and time

date	datetimeoffset
datetime2	smalldatetime
Datetime	Time

String

char	varchar
Text	??

Unicode string

nchar	nvarchar
ntext	??

Binary string

binary	varbinary
Image	??

Other data types

cursor	timestamp
hierarchyid	uniqueidentifier
sql_variant	xml
Table	Space type

SQL Server Facets-data types