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

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 server, we have a different type of data types available, those are