Introduction:
Here I will explain how to reset identity column value in SQL server or change or rest identity column value to 1 in SQL server. or reseed identity column value in SQL server.
Here I will explain how to reset identity column value in SQL server or change or rest identity column value to 1 in SQL server. or reseed identity column value in SQL server.
Description:
In
previous post I explained how set identity or auto incrementcolumn in SQL server. After set identity property on particular
column I inserted few records in table and that value automatically increase
whenever I inserted data that would be like this