Introduction:
Here I will explain how to set or create auto increment column or identity property on column in SQL server.
Here I will explain how to set or create auto increment column or identity property on column in SQL server.
Description:
In many situations we will insert records in table during that time we need to set unique value for that record if we use auto increment column then automatically generate unique number for newly insert record in table (Like generate EmployeeID of each employee whenever employee record inserted).