Data Types in SQL Server

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


Generally, we will define a column datatype while creating a table like as shown below. In SQL, we have different ways to declare columns in the table like through CREATE TABLE statement or directly creating a table in the database in SQL server management studio.

SQL Create Columns using Create Table Statement



UserId INT,

UserName VARCHAR(50),

Education VARCHAR(50),

Salary FLOAT


SQL Management Studio Create Columns in Table

SQL Server Table Columns with Different Data Types


In sql server, we have a different type of data types available, those are