Data Types in SQL Server

In SQL, the data type is an attribute 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, as shown below. In SQL, we have different ways to declare columns in the table like 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, we have different types of data types available. Those are