Quick Start Guide to SQL Server 7 -- Part 1, Page 5
Each field in a table needs to be of a specific data type. The following list describes each of them, starting with the most common.
| Data Type | Description |
| Varchar | Akin to the VB String data type. A variable length string containing up to 8,000 characters. Non-Unicode (doesn't support International characters) |
| Char | Akin to the VB String data type. A fixed-length string containing up to 8,000 characters. Non-Unicode. |
| Int | Akin to the VB Long data type. A whole number ranging from -2,147,483,647 to 2,147,483,647. |
| Smalldatetime | Akin to the VB Date data type. Holds any date and time combination between January 1st, 1900 to June 6th, 2079, with an accuracy of one minute. |
| Smallmoney | Akin to the VB Currency data type. Holds a currency amount between 214,748.3648 to 214,748.3647 |
| Smallint | Akin to the VB Integer data type. Holds a whole number between 32,768 to 32,767. |
| Tinyint | Akin to the VB Byte data type. Holds a whole number from between 0 to 255. |
| UniqueIndentifier | A 128-bit, Globally Unique Identifier (GUID) |
| Text | A variable-length string holding up to 2,147,483,647 characters. |
| Money | Akin to the VB Currency data type. Holds a currency amount ranging from -922,337,203,685,447.5808 to 922,337,203,685,447.5807 |
| Datetime | Akin to the VB Date data type. Can hold any date and time combination between Jan 1st, 1753 to December 31st, 1999, with an accuracy of 3.33 milliseconds. |
Digg
del.icio.us
Slashdot
DZone
Reddit
StumbleUpon
Facebook
FriendFeed
Furl
Newsvine
Google
LinkedIn
MySpace
Technorati
Twitter
Windows Live
YahooBuzz[Check us out next week for the second part in our SQL Server print-and-collect series. We'll be covering; security, indexes, relationships and Visual Basic data access code]
0 Comments (click to add your comment)
Comment and Contribute
Networking Solutions
