Posted on

If you need to manually insert a value into an identity column, but you don’t want to interrupt the current identity sequence, you can reseed the value.

If you go with a positive value, make sure you pick something higher than you’ll ever hit, to avoid an ID collision.

Or you can pick a negative number instead. This also gives you the advantage of picking a smaller meaningful number, and easy recognition that this ID is special. Also, if you go negative, you don’t need to even both with reseeding the identity.

View code on GitHub

Leave a Reply

Your email address will not be published. Required fields are marked *