title: Problem with default constraint "with values" in sql server
body: <p>I came to know that in Sql Server we have <code>WITH VALUES</code> that sets data inside <code>NULL</code> columns with specified values inside default constraint.
  But my query is not setting values in column that have already <code>NULL</code> in it,even when i used <code>WITH VALUES</code>,
  Please correct the query if I am wrong.
  my query is</p>
  
  <pre><code>GO
  CREATE TABLE [dbo].[DefaultTest]
  (
      [id] [int] NULL
  ) 
  GO
  INSERT INTO [dbo].[DefaultTest]
  SELECT NULL
  GO
  ALTER TABLE [dbo].[DefaultTest] 
  ADD  CONSTRAINT [con_Test]  DEFAULT 1 FOR [id]
  WITH VALUES
  GO
  SELECT * FROM [DefaultTest]
  GO
  DROP TABLE [DefaultTest]
  </code></pre>
  
  <p>Upon executing the query i noticed that still the column contains only NULL instead of 1.</p>