Fill in the column for each row in the database

Question

I just added a new column to the table that contains more than 1000 rows of data. I am wondering how I can update a new column with a piece of data for all rows in the database without having to do it manually.

What is the easiest way to do this?

I work with MS SQL 2005 server. Thank you in advance for your advice.

Answer 1

Try it.

UPDATE table_name SET column_name = value

It is indicated that the value you want to assign is a constant. It is right?

Answer 2

UPDATE  mytable
SET     newcolumn = 'newvalue'