An interesting question came up in class yesterday: how is a default column value stored, and what if some rows exist when a column is added and then the default value changes? An example scenario is this: Step 1: Create a table with two columns Step 2: Add 10 rows Step 3: Add a third column to the [&]

The post How are default column values stored? appeared first on Paul S. Randal.

http://feedproxy.google.com/~r/PaulSRandal/~3/wsdtzj81WBw/