binary(n) Fixed-length binary data. Maximum 8,000 bytes. varbinary(n) Variable-length binary data. Maximum 8,000 bytes. varbinary(max) Variable-length binary data. Maximum 2GB. image Variable-length binary data. Maximum 2GB.

Number types

Data type	Description	Storage
`tinyint`	Allows whole numbers from 0 to 255.	1 byte
`smallint`	Allows whole numbers between -32,768 and 32,767.	2 bytes
`int`	Allows whole numbers between -2,147,483,648 and 2,147,483,647.	4 bytes
`bigint`	Allows whole numbers between -9,223,372,036,854,775,808 and 9,223,372,036,854,775,807.	8 bytes
`decimal(p,s)`	Fixed precision and scale numbers. Allows numbers from $-10^{38}+1$ to $10^{38}-1$. `p`: Max total digits (1 to 38, default 18). `s`: Digits right of decimal (0 to p, default 0).	5-17 bytes
`numeric(p,s)`	Fixed precision and scale numbers (same as decimal).	5-17 bytes
`smallmoney`	Monetary data from -214,748.3648 to 214,748.3647.	4 bytes
`money`	Monetary data from -922,337,203,685,477.5808 to 922,337,203,685,477.5807.	8 bytes
`float(n)`	Floating precision number data from $-1.79E+308$ to $1.79E+308$. `n`: 4 or 8 bytes (`float(24)` is 4-byte, `float(53)` is 8-byte, default 53).	4 or 8 bytes
`real`	Floating precision number data from $-3.40E+38$ to $3.40E+38$.	4 bytes

Date types

Data type	Description	Storage
`datetime`	From Jan 1, 1753 to Dec 31, 9999 with 3.33 milliseconds accuracy.	8 bytes
`datetime2`	From Jan 1, 0001 to Dec 31, 9999 with 100 nanoseconds accuracy.	6-8 bytes
`smalldatetime`	From Jan 1, 1900 to Jun 6, 2079 with 1 minute accuracy.	4 bytes
`date`	Stores a date only. From Jan 1, 0001 to Dec 31, 9999.	3 bytes
`time`	Stores a time only to 100 nanoseconds accuracy.	3-5 bytes