SQL Datatypes
September 10, 2022 2022-09-11 4:47SQL Datatypes
Subhajit 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
