SQL Server 2005 data types


/ Published in: Other
Save to your folder(s)

## 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.




Copy this code and paste it in your HTML
  1. Data types listed above.

URL: http://www.teratrax.com/sql_guide/data_types/sql_server_data_types.html

Report this snippet


Comments

RSS Icon Subscribe to comments

You need to login to post a comment.