August 21, 2014
Hot Topics:
RSS RSS feed Download our iPhone app

Quick Start Guide to SQL Server 7 -- Part 1

  • November 19, 2002
  • By Karl Moore
  • Send Email »
  • More Articles »

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 TypeDescription
VarcharAkin to the VB String data type. A variable length string containing up to 8,000 characters. Non-Unicode (doesn't support International characters)
CharAkin to the VB String data type. A fixed-length string containing up to 8,000 characters. Non-Unicode.
IntAkin to the VB Long data type. A whole number ranging from -2,147,483,647 to 2,147,483,647.
SmalldatetimeAkin 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.
SmallmoneyAkin to the VB Currency data type. Holds a currency amount between 214,748.3648 to 214,748.3647
SmallintAkin to the VB Integer data type. Holds a whole number between 32,768 to 32,767.
TinyintAkin to the VB Byte data type. Holds a whole number from between 0 to 255.
UniqueIndentifierA 128-bit, Globally Unique Identifier (GUID)
TextA variable-length string holding up to 2,147,483,647 characters.
MoneyAkin 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
DatetimeAkin 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.

[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]





Page 5 of 5



Comment and Contribute

 


(Maximum characters: 1200). You have characters left.

 

 


Sitemap | Contact Us

Rocket Fuel