Data Types in SQL Server

1. Exact numeric type

Bigint

Int

Smallint

Tinyint

Bit

Money

Smallmoney

2. Balanced Data Type, Ms is recommendedVarchar (max)Replace text

Char

Varchar

Text

3. Approximate numeric type

Decimal

Numeric

Real

Float

4. Unicode string type

Nchar

Nvarchar

Ntext

5. binary data type,Recommended varbinary for MS(Max)In place of 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