Field types and descriptions in SQL SERVER

Data type
Description
Same meaning
Bit
1 bit; value: 0 or 1
Int
Integer
4 bytes; value range:-2 ^ 31 ~ 2 ^ 31-1
Smallint
2 bytes; value range:-2 ^ 15 ~ 2 ^ 15-1
Tinyint
1 byte; value range: 0 ~ 255
Decimal (p, s)
Numeric data with a fixed precision of P and a width of S
Numeric
Money
8 bytes, which stores the currency type; value range:-2 ^ 63 ~ 2 ^ 63-1
Small money
4 bytes, which stores the currency type. The value ranges from-214748.3648 ~ + 214748.3647 approximate numeric data types
Float (n)
N in 1 ~ Between 24, 4 bytes, 7-bit precision
N = 1 ~ 7 is real
N in 25 ~ Between 53, 8 bytes, 15-bit precision
= 8 ~ 15 is float
Datetime
8 bytes to describe the date and time of a day. The value is accurate to 1/300 seconds.
Smalldatetime
4 bytes, which describes the date and time of a day, precise to minutes
Cursor
References to a cursor
Timestamp
8 bytes, unique data stored in the database
Uniqueidentifier
16 bytes, stores the globally unique identifier (GUID)
Char (n)
The fixed length of a non-unicode string, n = 1 ~ 8000
Character (n)
Varchar (n)
Variable length, non-unicode string n = 1 ~ 8000
Char varying (n)
Text
Variable-length non-unicode data in the server code page. The maximum length is 23-1 characters
Nchar
Unicode string of fixed length n = 1 ~ 4000