If a DEFAULT constraint is included when a new column is add…
If a DEFAULT constraint is included when a new column is added to a table, the default value is applied to ________. To answer this question, use LiveSQL to test it out: create a simple table, add a row or two, then alter the table to add a new column with a default. See if the defaults were applied to the existing rows. Then add another row and see if the default was applied to that as well.