SQL Server Data Types

SQL Server > Data Types

A data type is an attribute that specifies the type of data that the object can hold.

Exact Numerics

• numeric, decimal
• int, bigint, smallint, tinyint
• bit
• money, smallmoney
  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	Spatial Types

  rowversion