how to add default data to a database 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)