Auto Generate IdFor Student

You can use below solutions but please go through below link before implementing the solution.

There are some disadvantages of Setting Identity column.

Below article shares the soultion for same

 

HI Dear,

 

 

 

Click on EmpId Column then below this form fill open then set  the Identity Seed =500 which id you want to start and set Identity increment id which you want to increment for every row.

 

  

 

                         OR

 

Hi ,

 

try this way

 

CREATE TABLE Student
(
ID int IDENTITY(501,1) PRIMARY KEY,
LastName varchar(255) NOT NULL,
FirstName varchar(255),
Address varchar(255),
City varchar(255)
) 

 

 

 INSERT INTO Student(FirstName,LastName)VALUES ('Lars','Monsen')

ex- CREATE TABLE [dbo].[t]( [id] [int] IDENTITY(500,1) NOT NULL, [name] [nchar](10) NULL )