title: Adding auto incrementing primary key to an existing table in SQL SERVER 2005
body: <p>I have a table with 8,000 rows of data and will be adding more. but I forgot to put a primary key in the beginning. so that each row has a unique key. later i added a primary key column. but that column is NULL now.</p>
  
  <p>I want the first row to start at ID 1 and increment all the way up to the last row at ID 8000. How do I update all of the rows with a single query?</p>
  
  <p>i am using SQL Server 2005.</p>