title: SQL server query to add column with default value
body: <p>I'm trying to change my SQL server database by adding another column to a table with 0 as a default value.</p>
  
  <p>I thought this script worked in the past (for another table), but now I have an error when I try to execute the script</p>
  
  <blockquote>
    <p><strong>The script</strong></p>
  </blockquote>
  
  <pre><code>ALTER TABLE Whatever
  ADD WhateverColumn tinyint NOT NULL 
  DEFAULT(0)
  </code></pre>
  
  <blockquote>
    <p><strong>The errors</strong></p>
  </blockquote>
  
  <ul>
  <li>On hovering mouse over "NOT": Incorrect syntax near 'NOT'. Expecting 'TO'</li>
  <li>On hovering mouse over "0": Incorrect syntax near 0. Expecting '(', or SELECT</li>
  </ul>
  
  <p>Anyone knows what's wrong with this?</p>