SQL Datatypes
September 10, 2022 2022-09-11 4:47SQL 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
This is Subhajit Sinha, with more than 8 years of experience as a full stack developer in renowned Multinational Companies, here in this portal as an online tutor I will guide you personally to level up your programming skills and also will coach you to augment your career and salary as well.
Search
Popular posts
