Work with data types
Columns and variables used in Transact-SQL each have a data type. The behavior of values in expressions depends on the data type of the column or variable being referenced. For example, as you saw previously, you can use the + operator to concatenate two string values, or to add two numeric values.
The following table shows common data types supported in a SQL Server database.
Exact Numeric
Approximate Numeric
Character
Date/Time
Binary
Other
tinyint
float
char
date
binary
cursor
smallint
real
varchar
time
varbinary
hierarchyid
int
text
datetime
image
sql_variant
bigint
nchar
datetime2
table
bit
nvarchar
smalldatetime
timestamp
decimal/numeric
ntext
datetimeoffset
uniqueidentifier
numeric
xml
money
geography
smallmoney
geometry