Friday, January 31, 2014

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;

1 comment:

  1. Harrah's Reno - Mapyro
    Directions 울산광역 출장안마 to 통영 출장안마 Harrah's Reno (formerly Harrah's Reno) with real-time 속초 출장마사지 driving 대전광역 출장마사지 directions and reviews. 출장샵 Casino, Hotel, Pool & Event Center. Directions.