I have a table with huge amount of data. I'd like to add extra column id
and use it as a primary key. What is the better way to fill this column with values from one 1
to row count
Currently I'm using cursor and updating rows one by one. It takes hours. Is there a way to do that quicker?
Thank you
This question is related to
sql
sql-server
cursor
primary-key
Source: Stackoverflow.com