0

When i insert a new record,Sql server database table is not save well-order auto increment.How can i solve it? database table id increment of 1000

enter image description here

w

sedatbzdgn
  • 251
  • 1
  • 3
  • 5

1 Answers1

0

In order to prevent collisions in rapid insertions, Sql Server provides a default CACHE value for the auto incremented column. You should not rely on the order of this column for the insert sequence of the records. You can use a sequence generator with the NO CACHE setting as explained here

tuncay altınpulluk
  • 403
  • 1
  • 4
  • 9