sql for all tables in a database ad a default value or binding for column decimal value sql server code example

Example: alter table add column with default value

ALTER TABLE Protocols
ADD ProtocolTypeID int NOT NULL DEFAULT(1)