SQL: add default value to column

ALTER TABLE Employee ADD CONSTRAINT DF_SomeName DEFAULT N'SANDNES' FOR CityBorn;

Reference: How to set a default value for an existing column