Tag Info

New answers tagged

-4

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 ...


3

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