[Origin]: http://www.c-sharpcorner.com/blogs/how-to-reset-identity-column-values-in-sql-server1
Step 1: Create table.
Step 2: Insert some sample data.
When we run above query the second insert statement will failed because of varchar(10) length.
Step 3: Check the identity column value.
Even second insert was failed but the identity value is increased .if we insert the another record the identity value is 3.
Step 4: Reset the identity column value.
Advertisements