MS SQL update column with auto incremented value

i recently imported some old data to a new SQL table and forgot to set the ID column to auto increment.

Now i have several “NULL”s in the column named ID.

Is there a way I can update all ID columns with an unique ID automatically?
sadly i have no clue how

After that I will be able to set the column to INT and Auto Increment.

Thank you for your help.


Source: sql

Leave a Reply