CipherIS
asked on
SQL SERVER - Index skipped a number
I have a question. I was debugging a problem. I used begin transaction and rollback transaction. The result was that the index which is auto incremented created a record and removed it.
I have a request to fix the table so there is not gap between the numbers. Example 1, 2, 3, --, 5.
Is there a way to renumber 5 to 4 and then continue from there without skipping a number?
I have a request to fix the table so there is not gap between the numbers. Example 1, 2, 3, --, 5.
Is there a way to renumber 5 to 4 and then continue from there without skipping a number?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER