mssql alter table add column not null default value code example

Example 1: add new column not null sql server

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

Example 2: mysql alter table column nullable

ALTER TABLE mytable MODIFY mycolumn VARCHAR(255);