April 01, 1998 02:01 PM
Questions, Answers, and Tips About SQL Server
Rating:

(0)
Windows IT Pro
InstantDoc ID #3102
Q:
If you roll back an insert transaction into a table with an identity column, that identity value gets used up, and the table has a gap in the identity numbers. Usually, a gap isn't a problem, but I'm cheating a bit with an accounts receivable system and using an identity column to generate invoice numbers. How can I eliminate the gaps?
...
You must be a paid Professional Member to access this entire article.
Already a Professional Member? Please log in now: