SQL Server Identity column value suddenly jumps to 1002

Question

i am using a column for Seuqence which is INT  NOT NULL  PK and AutoGenerated by 1  to some extent it maintains the sequence but after a while it disturbs the sequence  here it is

Mudassar · Accepted Answer

Identity will never decrease its value1 If record is delete that value will never been assigned to othe record2 If insert fails that time also Identity is incremented Though no record is inserted

Azim · Answer

You need to insert record in such a way that first you need to get the Max Id  1 from table and insert the record with this Id

SQL Server Identity column value suddenly jumps to 1002

Company

Explore

Follow us

Contact Us