Introduction:
Here I will explain how to set or add auto increment column in SQL server or create auto increment column in SQL server 2008 using management studio.
Here I will explain how to set or add auto increment column in SQL server or create auto increment column in SQL server 2008 using management studio.
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).