title: WITH VALUES TSQL
body: <p>I have been trying to understand what the <code>WITH VALUES</code> statement does?</p>
  
  <p>I cant seem to find any documentation that explains it properly.</p>
  
  <pre><code>ALTER TABLE Table1 
  ADD newGuidId UniqueIdentifier NULL CONSTRAINT DF_Guid Default newid()
  with values
  </code></pre>