Data Types List in SQL Server with Examples

  Keywords : SQL server data types, Data types list in sql server, Different types of data types in sql server with example, MS SQL data types list with examples, Available Data types in sql server

Here we will learn different type of data types available in sql server with examples.

SQL Data Types

In SQL Server data type is an attribute which we will used to specify type of the data column can hold like numeric type, character type, binary type, date and time type, etc. 


Generally we will declare column datatype while creating table like as shown below. We have different ways to declare columns like through query or directly while creating table in database

Method 1



UserId INT,

UserName VARCHAR(50),

Education VARCHAR(50),

Salary FLOAT


Method 2

SQL Server Table Columns with Different Data Types


In SQL Server we have different type of Data Types those are 


         - Exact Numeric Data Types (int, smallint, bigint, etc.)


         - Approximate Numeric Data Types (float, real)


         - Date and Time Data Types (date, datetime, time, smalldatetime, etc.)


         - Character String Data Types (char, varchar, text, etc.)


         - Unicode character string data types (nchar,nvarchar,ntext)


         - Binary Data Types


         - Miscellaneous Data Types or Other Data Types