Home Forums SQL Server 2014 Development - SQL Server 2014 Add new column with default value RE: Add new column with default value
John Mitchell-245523
SSC Guru
Points: 148809
More actions
April 20, 2015 at 3:12 am
#1791955
I think he's confused his requirement: he mentions "already inserted rows" and "already inserted columns" almost in the same breath. I think Gianluca's solution will work for him; alternatively he could specify NOT NULL when adding the column.
John