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

CREATE TABLE SampleTable
(
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