How to generate sequential numbers in an Identity column

Question

I have a database table Person with primary key ID, I set the identifier specification to "Yes" and the identity increment to 1 to make it auto-increment.

But all I am having are random numbers like 1, 33, 34, 1034, 1035, 2036, 3036, 4037

I want to make it Sequential like 1 2 3 etc...

Start by posting the relevant code at least. If you want to know how to ask good questions see the document [here](http://stackoverflow.com/help/how-to-ask) — Spaceman Spiff, Oct 14 '14 at 22:37
You need to show us what you have tried to solve the problem. — wookie919, Oct 14 '14 at 22:42
Questions about Stack Overflow itself should be posted on https://meta.stackoverflow.com — juergen d, Oct 14 '14 at 22:45
[Stop making assumptions about `IDENTITY`](https://sqlblog.org/2009/10/12/bad-habits-to-kick-making-assumptions-about-identity), stop worrying about gaps - they are really **NOT** a problem! — marc_s, Oct 15 '14 at 05:05

score 0 · Answer 1 · answered Oct 14 '14 at 22:40

An identity column guarantees sequential values but allows gaps. Gaps may occur due to row deletion, transaction rollbacks, server restart, or concurrency. If you don't want gaps, don't use IDENTITY. Consider using ROW_NUMBER() in your queries instead of you don't want gaps.

How to generate sequential numbers in an Identity column

1 Answers1