I already have a table which consists of data. I need to alter table to add two new columns which are not null. How can I do that without losing any existing data?
Here's what I tried (via right-clicking the table and selecting Design):
Added new columns 'EmpFlag' (bit, null), 'CreatedDate' (datetime, null)
Updated 'EmpFlag' column in the table, to have some valid values. (Just wanted to work on one field, so I didn't update 'CreatedDate' field)
Now right clicked table, design, and made it not null.
When I tried to save, this error message appeared:
Thanks in advance!