Identity Column in SQl Server

This article will show you how you can set or make a column as identity or auto incremented in our sql server table column.

For this first we will create a table

Now in this table add a column named as “Id”.

Now set the column identity Yes.

Now add other column name and save table.

Now your table have been created

Now we will insert some data to table to check whether we are getting auto incremented value in table or not

Insert into StudentData(Name,Address) Values('Name1','Address1'); Insert into StudentData(Name,Address) Values('Name2','Address2'); Insert into StudentData(Name,Address) Values('Name3','Address3');

 Now check the output

In above table u can see that the Id column value is auto entered we have not passed the id column value.

Thanks for reading the article please let me know you comment.