Pages

Tuesday, August 16, 2011

Add default values in to a new column for existing rows

If you want to add a new column with a default constraint to a table and insert the default value to all the existing rows, use WITH VALUES expression as given below:

No comments:

Post a Comment