title: Add 'Guid' column with NewId() as default value, does not work properly
body: <p>I have to add a column called 'Guid' that should be have default value. It's not primary-key.
  So, I did it as below:</p>
  
  <pre><code>ALTER TABLE myTable ADD [Guid] uniqueidentifier NOT NULL DEFAULT(NewId())
  </code></pre>
  
  <p>Ok, now I have a column that has acceptable value. But after insertion a new row, the Guid column's value is</p>
  
  <pre><code>00000000-0000-0000-0000-000000000000
  </code></pre>
  
  <p>I tested it with another name:  </p>
  
  <pre><code>ALTER TABLE MyTable ADD Guids uniqueidentifier NOT NULL DEFAULT(NewId())  
  </code></pre>
  
  <p>and there is no problem with this. It seems that the main problem is the name of column (<code>Guid</code>), maybe. Is that true?
  So, How can I fix that, since I can't use another name for it.</p>