Click here to Skip to main content
15,906,329 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
Hi All,

I have a table ABC and Column EmployeeId and salary.
I have set identity of Employee Id.
and have inserted values in tables as

1   455454
2   45454
3   4545454
4   5656565
5   4545454

Now if I delete record at no four and insert a new record then it shows as:

1 455454
2 45454
3 4545454
5 4545454
6 56565645

but I want it as no 4
1 455454
2 45454
3 4545454
4 56565645
5 4545454

Please let me know how to do it.
Thanking You

Mohammad Wasif
Updated 18-Mar-11 0:29am
Costica U 18-Mar-11 6:00am    
You meant "How to reset identity specification in sql server"?

Share this answer
If you do not want to reseed the table using CHECKIDENT, use the below script to insert the record.

INSERT INTO ABC (EmployeeId, Salary)
SELECT MAX(EmployeeId)+1
, [YourSalaryValue]
Share this answer

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900