What is an Auto Increment in SQL SERVER?
Auto Increment:-
SQL AUTO INCREMENT allows a unique number that is to be generated automatically whenever the new record is inserted into the table.
Syntax:-
Create Table Table_name
(
EmpId int NOT NULL AUTO INCREMENT,
Employee_Name Varchar(200),
Employee_Address Varchar(200),
PRIMARY KEY (EmpId )
)
Auto Increment:-
SQL AUTO INCREMENT allows a unique number that is to be generated automatically whenever the new record is inserted into the table.
Syntax:-
Create Table Table_name
(
EmpId int NOT NULL AUTO INCREMENT,
Employee_Name Varchar(200),
Employee_Address Varchar(200),
PRIMARY KEY (EmpId )
)