/ Published in: Other
## Exact numerics
<b>Type </b>
<b>From </b>
<b>To </b>
bigint
-9,223,372,036,854,775,808
9,223,372,036,854,775,807
int
-2,147,483,648
2,147,483,647
smallint
-32,768
32,767
tinyint
255
bit
1
decimal
-10^38 +1
10^38 –1
numeric
-10^38 +1
10^38 –1
money
-922,337,203,685,477.5808
+922,337,203,685,477.5807
smallmoney
-214,748.3648
+214,748.3647
numeric and decimal are Fixed precision and scale data types and are functionally equivalent.
## Approximate numerics
<b>Type</b>
<b>From</b>
<b>To</b>
float
-1.79E + 308
1.79E + 308
real
-3.40E + 38
3.40E + 38
## datetime and smalldatetime
<b>Type</b>
<b> From</b>
<b>To</b>
datetime (3.33 milliseconds accuracy)
Jan 1, 1753
Dec 31, 9999
smalldatetime (1 minute accuracy)
Jan 1, 1900
Jun 6, 2079
## Character Strings
<b>Type</b>
<b>Description</b>
char
Fixed-length non-Unicode character data with a maximum length of 8,000 characters.
varchar
Variable-length non-Unicode data with a maximum of 8,000 characters.
varchar(max)
Variable-length non-Unicode data with a maximum length of 231 characters (<b>SQL Server 2005 only</b>).
text
Variable-length non-Unicode data with a maximum length of 2,147,483,647 characters.
## Unicode Character Strings
<b>Type</b>
<b>Description</b>
nchar
Fixed-length Unicode data with a maximum length of 4,000 characters.
nvarchar
Variable-length Unicode data with a maximum length of 4,000 characters.
nvarchar(max)
Variable-length Unicode data with a maximum length of 230 characters (<b>SQL Server 2005 only</b>).
ntext
Variable-length Unicode data with a maximum length of 1,073,741,823 characters.
## Binary Strings
<b>Type</b>
<b>Description</b>
binary
Fixed-length binary data with a maximum length of 8,000 bytes.
varbinary
Variable-length binary data with a maximum length of 8,000 bytes.
varbinary(max)
Variable-length binary data with a maximum length of 231 bytes (<b>SQL Server 2005 only</b>).
image
Variable-length binary data with a maximum length of 2,147,483,647 bytes.
<b>Type </b>
<b>From </b>
<b>To </b>
bigint
-9,223,372,036,854,775,808
9,223,372,036,854,775,807
int
-2,147,483,648
2,147,483,647
smallint
-32,768
32,767
tinyint
255
bit
1
decimal
-10^38 +1
10^38 –1
numeric
-10^38 +1
10^38 –1
money
-922,337,203,685,477.5808
+922,337,203,685,477.5807
smallmoney
-214,748.3648
+214,748.3647
numeric and decimal are Fixed precision and scale data types and are functionally equivalent.
## Approximate numerics
<b>Type</b>
<b>From</b>
<b>To</b>
float
-1.79E + 308
1.79E + 308
real
-3.40E + 38
3.40E + 38
## datetime and smalldatetime
<b>Type</b>
<b> From</b>
<b>To</b>
datetime (3.33 milliseconds accuracy)
Jan 1, 1753
Dec 31, 9999
smalldatetime (1 minute accuracy)
Jan 1, 1900
Jun 6, 2079
## Character Strings
<b>Type</b>
<b>Description</b>
char
Fixed-length non-Unicode character data with a maximum length of 8,000 characters.
varchar
Variable-length non-Unicode data with a maximum of 8,000 characters.
varchar(max)
Variable-length non-Unicode data with a maximum length of 231 characters (<b>SQL Server 2005 only</b>).
text
Variable-length non-Unicode data with a maximum length of 2,147,483,647 characters.
## Unicode Character Strings
<b>Type</b>
<b>Description</b>
nchar
Fixed-length Unicode data with a maximum length of 4,000 characters.
nvarchar
Variable-length Unicode data with a maximum length of 4,000 characters.
nvarchar(max)
Variable-length Unicode data with a maximum length of 230 characters (<b>SQL Server 2005 only</b>).
ntext
Variable-length Unicode data with a maximum length of 1,073,741,823 characters.
## Binary Strings
<b>Type</b>
<b>Description</b>
binary
Fixed-length binary data with a maximum length of 8,000 bytes.
varbinary
Variable-length binary data with a maximum length of 8,000 bytes.
varbinary(max)
Variable-length binary data with a maximum length of 231 bytes (<b>SQL Server 2005 only</b>).
image
Variable-length binary data with a maximum length of 2,147,483,647 bytes.
Expand |
Embed | Plain Text
Copy this code and paste it in your HTML
Data types listed above.
URL: http://www.teratrax.com/sql_guide/data_types/sql_server_data_types.html