add column not null default code example
Example 1: alter table add column with default value
ALTER TABLE Protocols
ADD ProtocolTypeID int NOT NULL DEFAULT(1)
Example 2: add new column not null sql server
ALTER TABLE MY_TABLE
ADD STAGE INT NOT NULL
DEFAULT '0';