Answers for "sql server how to make int column not null with default 0"

alter table add column with default value

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

Posted by: Guest on August-03-2020

Code answers related to "sql server how to make int column not null with default 0"