sql server how to make int column not null with default 0 code example
Example: alter table add column with default value
ALTER TABLE Protocols
ADD ProtocolTypeID int NOT NULL DEFAULT(1)
ALTER TABLE Protocols
ADD ProtocolTypeID int NOT NULL DEFAULT(1)