MSSQL - How to add new integer column to the table with default value

Watch this example on YouTube





ALTER TABLE table_name
ADD IntegerColumn int NOT NULL DEFAULT(123)