sql server alter column type with default 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)