Blog

SQL Datatypes

SQL

SQL Datatypes

Data Types

1. Exact numerics
2. Approximate numerics
3. Date and time
4. Character strings
5. Unicode character strings
6. Binary strings
7. Other data types

Exact numerics

bigint
bit
decimal
int
money
numeric
smallint
smallmoney
tinyint
Approximate numerics
float
real
Date and time
date
datetime
datetimeoffset
smalldatetime
datetime2
time
Character strings
char
varchar
text
Unicode character strings
nchar
nvarchar
text
Binary strings
binary
varbinary
image

Other data types

rowversion

cursor
hierarchyid
sql_variant
cursor
Spatial Geometry Types
table
uniqueidentifier
xml
Spatial Geography Types

Please comment and share if you like this post and tell us about how we can enhance #dotnetcoaching to be the best online dot net tutor site. Thanks

Subhajit