Tag Info

New answers tagged


If you only need to eliminate the last rows which have not followed the incremental value of an identity field, there is an easy and safe way: first delete the last record(s) which have 'jumped' change the data type of your Identity Field (from int to bigint or vice versa) save the table add a new record, and check it assigns the number of the highest ...


This can only be if ... you did not actually commit your transaction (yet) and running the second query in a different transaction. or you have other transactions writing to the table in the meantime or something is seriously broken or you are dealing with two different tables: It's worth mentioning that your ALTER TABLE commands are on ...

Top 50 recent answers are included