Adding a not null column to an Existing Table

ALTER TABLE dbo.My_Table
    ADD New_Column VARCHAR(100) NOT NULL
        CONSTRAINT DF_My_Table_1 DEFAULT 'Unspecified' WITH VALUES;