sql server - WITH VALUES TSQL

Question

I have been trying to understand what the WITH VALUES statement does?

I cant seem to find any documentation that explains it properly.

ALTER TABLE Table1 
ADD newGuidId UniqueIdentifier NULL CONSTRAINT DF_Guid Default newid()
with values

question from:https://stackoverflow.com/questions/18680974/with-values-tsql

Answer 1

WITH VALUES applies default values to the null fields

http://technet.microsoft.com/en-us/library/ms187742.aspx and a short blog post about it.