SQL SERVER DATA TYPES

In this session we will know SQL-SERVER data types. We came to know from the previous posts that every column in a table has a specific data type and allows only that particular type of data to be inserted into that column. A data type is the term used to specify the type of data that an object is carrying such as character data, integer data, date and time data, binary data etc.

Based on the type of data, data types can be categorized as follows1) String data types
2) Integer data types

3) Date and time data types

4) Unicode data types

5) Binary data types

6) Miscellaneous data types

We shall  know what are the data types under each category mentioned above.

  STRING DATA TYPES:

The following are the list of string data types supported by SQL SERVER.

INTEGER DATA TYPES:

DATE DATA TYPES:

 MISCELLANEOUS DATA TYPES:

If one needs any further information regarding these data types, you can use the following link,

http://msdn.microsoft.com/en-IN/library/ms187752.aspx

In the next session,we will learn some basic sql commands and how to create database, tables in SQL-server.