Data is any piece of information which has some meaning or significance.
Data Type indicates the type of data an object holds. In SQL Server Data types are very important for creating tables, for declaring variables etc.,
In SQL Server Data types are broadly classified into the following types based on the type of data it holds
- Exact Numeric
- Approximate Numeric
- Character Strings
- Date and time
- Binary Characters
- Unicode Characters
- Other data types.
Data types are mainly used for the following purpose:
- Creating columns in tables and views
- For declaring variables
- For passing variables in stored procedures and functions.
