SQL Data Types

SQL data type is an attribute that specifies type of data of any object. Each column, variable and expression
has related data type in SQL.
You would use these data types while creating your tables. You would choose a particular data type for a table
column based on your requirement.
SQL Server offers six categories of data types for your use:

Exact Numeric Data Types :-

Approximate Numeric Data Types :- 

   

Date and Time Data Types :-

Note :-  Here, datetime has 3.33 milliseconds accuracy where as smalldatetime has 1 minute accuracy.

Character Strings Data Types :-

Unicode Character Strings Data Types :-

Binary Data Types :-

Misc Data Types :-