| SQL Server 2005 - Data types | HomePage | ||
| Powered by Webelink.com | # | Type | Class | Description |
| 1. | binary | binary | Fixed-length binary data with a maximum length of 8,000 bytes in size |
| 2. | varbinary | binary | Variable-length binary data can be very large if space permits |
| 3. | smalldatetime | datetime | A timestamp, date and time data from January 1, 1900, through June 6, 2079 |
| 4. | datetime | datetime | A timestamp, date and time data from January 1, 1753, through December 31, 9999 |
| 5. | timestamp | datetime | Generates automatically a database-wide unique number that gets updated every time a row gets updated a row gets updated |
| 6. | image | image | Variable-length binary data with a maximum length of up to 2GB in size |
| 7. | bit | integer | Integer data with either a 1 or 0 value (also known as true or false) |
| 8. | tinyint | integer | Integer data from 0 through 255 |
| 9. | smallint | integer | Integer data from -32,768 through 32,768 |
| 10. | int | integer | Integer data from -2.1 billion through 2.1 billion |
| 11. | bigint | integer | Integer data from -9.22 billion through 9.22 billion |
| 12. | uniqueidentifier | misc | A system-wide global unique identifier (GUID) |
| 13. | smallmoney | money | Monetary data values from -214 thousand through 214 thousand |
| 14. | money | money | Monetary data values from -922 trillion through 922 trillion |
| 15. | decimal | number | Fixed precision and scale numeric data from -10^38 through 10^38 |
| 16. | numeric | number | Fixed precision and scale numeric data from -10^38 through 10^38 |
| 17. | float | number | Floating-point precision number data, can have an enormous range |
| 18. | real | number | Floating-point precision number data, can have an enormous range |
| 19. | char | text | Fixed-length non-Unicode data with a maximum length of 8,000 characters |
| 20. | nchar | text | Fixed-length Unicode data with a maximum length of 4,000 characters |
| 21. | ntext | text | Variable-length Unicode data with a maximum length of up to 2GB |
| 22. | nvarchar | text | Variable-length Unicode character data can be very large if space permits |
| 23. | text | text | Variable-length non-Unicode data with a maximum length of up to 2GB |
| 24. | varchar | text | Variable-length non-Unicode character data can be very large if space permits |
| 25. | XML | xml | Up to 2GB of XML based data |
| © Copyright 2003-2010 webelink.com. All Rights Reserved. | Click to Email for Info | Terms of Use | | |||