SQL Server table jumping numbers on auto increment id's

Asked Nov 14 '17 at 11:34

Active Nov 14 '17 at 11:35

Viewed 28 times

In doing some testing on a new table in my SQL Server database, I noticed the auto-incremented id's were not sequential, which I know can be the case. BUT, as you can see from the picture below, after a dozen or so entries, the id field is up to using 10005!. Why is the id jumping higher like that? Is there any way to control that? Otherwise I can envision 20 digit id numbers in the future which isn't preferred.

edited Nov 14 '17 at 11:35

marc_s

732,580
175
1,330
1,459

asked Nov 14 '17 at 11:34

dinotom

4,990
16
71
139

one way is `row_number()` you could use explicitly assign ranking – Yogesh Sharma Nov 14 '17 at 11:36
https://stackoverflow.com/questions/14146148/identity-increment-is-jumping-in-sql-server-database – RAJNIK PATEL Nov 14 '17 at 11:38

SQL Server table jumping numbers on auto increment id's

0 Answers0