Services
Technology Web App Development Mobile App Development Windows App Development Database Development UI/UX Development Cloud Development SEO Digital Marketing Guest Posting Content Writing Artificial Intelligence Data Science ERP Development CRM Development CMS Development LMS Development Business Listing Blockchain Technology Startup Promotion AI Tools Integration
Products
Data Converter Cleaner TUC - Unit Converter Import Export Survey Manager Tweet Controller
Developer
Article Blog Forum Interview Beginner News Startup Quiz
Users
Career
Apply Job Internship
Pricing
Login Sign Up Get a Quote

forum

home / developersection / forums / why is use identity() in sql server, how to make an auto-incremented table in sql server?
Ask Question

Why is use IDENTITY() in SQL Server, how to make an auto-incremented table in SQL Server?

Ravi Vishwakarma 875 22 Sep 2021

Why is use IDENTITY() in SQL Server, how to make an auto-incremented table in SQL Server? 

database databasesql serversql
Updated 22 Sep 2021
Ravi Vishwakarma
Ravi Vishwakarma

Software Developer

Hi, my self Ravi Vishwakarma. I have completed my studies at SPICBB Varanasi. now I completed MCA with 76% form Veer Bahadur Singh Purvanchal University Jaunpur. SWE @ MindStick | Software Engineer | Web Developer | .Net Developer | Web Developer | Backend Engineer | .NET Core Developer

Message

1 Answers

Ashutosh Kumar Verma
Ashutosh Kumar Verma 27 Sep 2021
Report Abuse

SQL Identity:

 Auto Increment allows a unique number which is automatically generated every time a new record is inserted in the table. SQL Auto Increment is mainly used in Primary Field.

Or, we can say that when a new record is inserted in database table then the identity value increased automatically for that record. Often it created as in primary key that I would like to created automatically when a new record is inserted. In other word Identity is called as auto-increment.

Syntax- 

CREATE TABLE table_name  (

Column_name datatype IDENTITY(‘start from’, ‘increment by number’) Constraint,

Column_name2 datatype,

Column_nameN datatype );

Example:

There is database table is created with Identity Constraint in primary as like below, 

create table Student(

stuID int IDENTITY(101,1) primary key,

stuRollNO int,

stuName varchar(255),

stuCourse varchar(255),

stuAge int );

Ashutosh Kumar Verma

Now, records is inserted in the above created table, 

insert into Student

Values(123,'Ravi Vishwakarma','MCA',23),

(124,'Shriyam','Marketing',22);

Ashutosh Kumar Verma

It you observe that in above SQL statement in which record is insert in database table column ‘stuID’ is not inserted through command, it is automatically generated. So stuID in automatically generated when I insert a new record into that table because ‘stuID’ is defined as Identity.

MindStick Training