Auto-increment value does NOT gradually increasing

Asked Jul 12 '20 at 19:24

Active Jul 12 '20 at 20:02

Viewed 49 times

Although there are no deleted rows or any rollback processes, the numbering is NOT increasing regularly, why?

The [id] column is auto increment by 1.

edited Jul 12 '20 at 20:02

Dale K

asked Jul 12 '20 at 19:24

Tariq Khalifa

5

Gaps are to be expected. Take a peek at https://dba.stackexchange.com/questions/106209/unexpected-gaps-in-identity-column – John Cappelletti Jul 12 '20 at 19:25
2

Just to add, look at the REMARKS section https://learn.microsoft.com/en-us/sql/t-sql/statements/create-table-transact-sql-identity-property?view=sql-server-ver15 – John Cappelletti Jul 12 '20 at 19:29
2

[Identity increment is jumping in SQL Server database](https://stackoverflow.com/questions/14146148/identity-increment-is-jumping-in-sql-server-database) – Lukasz Szozda Jul 12 '20 at 20:02
Gaps are to be expected, but anyway, in your sample dataset, are you actually ordering by `id`? – Nick.Mc Jul 12 '20 at 21:32

0 Answers0