Insert same column value into a table

[jcs1953]

I have a table in which I added a new column named test_name. I need to populate all rows in this new column with the same value (Sedrate). How can I do this?
Thanks.

 

[markros]

One of the ways would be

UPDATE myTable SET Test_Name = 'Sedrate'

You can also specify default value for the column.

However, is there any sense to have a column with the same information in the whole table?

 

[jcs1953]

Not really, except in my case it was the easiest way out I could think of. The table is small and will never have data added. I have two db, oracle and mssql. I have to combine the data from the two to display on a internal webpage. The oracle db table has the test name and the mssql table didn't.
Thanks for your help.