SQL

add new column not null sql server

ALTER TABLE MY_TABLE
ADD STAGE INT NOT NULL
DEFAULT '0';

sql add column int nullable

ALTER TABLE YourTable
  ADD Foo INT NULL /*Adds a new int column existing rows will be 
                     given a NULL value for the new column*/

sql - add not null column take values from other column

-- add the column (as nullable)
alter table mytable add created_year int;

-- update the values on existing rows
update items set created_year = year(created_date);

-- make the column not nullable
alter table mytable alter column created_year int not null;