Tutorial by Examples

There are two basic classes of exact numeric data types - Integer, and Fixed Precision and Scale. Integer Data Types bit tinyint smallint int bigint Integers are numeric values that never contain a fractional portion, and always use a fixed amount of storage. The range and storage sizes o...

float [(n)] real These data types are used to store floating point numbers. Since these types are intended to hold approximate numeric values only, these should not be used in cases where any rounding error is unacceptable. However, if you need to handle very large numbers, or numbers with an ...

These types are in all versions of SQL Server datetime smalldatetime These types are in all versions of SQL Server after SQL Server 2012 date datetimeoffset datetime2 time

char varchar text

nchar nvarchar ntext

binary varbinary image

cursor timestamp hierarchyid uniqueidentifier sql_variant xml table Spatial Types