title: How to set a default value for an existing column
body: <p>This isn't working in SQL Server 2008:</p>
  
  <pre><code>ALTER TABLE Employee ALTER COLUMN CityBorn SET DEFAULT 'SANDNES'
  </code></pre>
  
  <p>The error is:</p>
  
  <blockquote>
    <p>Incorrect syntax near the keyword 'SET'.</p>
  </blockquote>
  
  <p>What am I doing wrong?</p>