title: How to add a default value to an already existing column?
body: <p>I have an existing column in my SQL Server database. I have tried about everything I can think of but can not get a default value to be added to the column. What works in every other database is </p>
  
  <pre><code>alter table mytable 
    alter column mycolumn set default(now()) --mycolumn is a datetime
  </code></pre>
  
  <p>How do I do this in SQL Server? </p>
  
  <p>The error I get for that exact syntax is <code>incorrect syntax near the keyword 'set'</code></p>