title: Fill a Column for Every Row in a Database
body: <p>I just added a new column to a table which has over 1000 rows of data. I am wondering how I can update the new column with a piece of data for all of the rows in the database without having to manually do it.</p>
  
  <p>What is the easiest way to accomplish this?</p>
  
  <p>I am working with a MS SQL 2005 server. Thank you in advance for your advice.</p>