[Summary -- Data Types in SQL Server]

Data Types in SQL Server

1. Exact numeric type
Bigint
Int
Smallint
Tinyint
Bit
Money
Smallmoney

2. Dense data type. We recommend that you use varchar (max) instead of text in ms.
Char
Varchar
Text

3. Approximate numeric type
Decimal
Numeric
Real
Float

4. Unicode string type
Nchar
Nvarchar
Ntext

5. binary data type. In ms, varbinary (max) is recommended to replace the image data type. max = 231-1
Binary (n) Stores fixed-length binary data
Varbinary (n) Stores variable-length binary data in the range of N ~ (1,8000)
Image Stores image information

6. Date and Time types, with different data ranges and exact differences
Datetime
Smalldatetime

7. Special Purpose Data Types
Cursor
SQL-variant
Table
Timestamp
Uniqueidentifier
XML

-----------------------------------------