ALTER TABLE [dbo].[IndividualAttribsMeta] ADD [PlaysBridge] varchar(250) DEFAULT 'Plays Bridge'What I would like to do is add the [PlaysBridge] column to the [dbo].[IndividualAttribsMeta] table and have the value 'Plays Bridge' inserted for this column in every row, within the same transaction covering the ALTER TABLE/ADD COLUMN action. When I run the above command, all I get is a Null as the column value. As far as "every row" is concerned, there will only ever be a single row in this table.