Almost a decade before, I came across a requirement where I needed to add multiple columns in a table with default value. It took a while on that time to figure it out.
I found it in my old SQL Projects repository and thought to share it with you.
-- Creating a table and adding a row
CREATE TABLE TestTable1(Id INT, SomeCol VARCHAR(10))
INSERT INTO TestTable1 SELECT 10, 'abcdefgh'
-- Adding Multiple Columns With Default
Values
ALTER TABLE TestTable1
ADD Col1 VARCHAR(100) NOT NULL DEFAULT('SomeInformation'),
Col2
INT NOT NULL DEFAULT(999)
GO
-- Retrieve Data from Table
SELECT * FROM TestTable1
GO
