title: Add a column of zeros to table sql server
body: <blockquote>
    <p><strong>Possible Duplicate:</strong><br>
    <a href="https://stackoverflow.com/questions/92082/add-column-with-default-value-to-existing-table-in-sql-server">Add column, with default value, to existing table in SQL Server</a>  </p>
  </blockquote>
  
  
  
  <p>I have a table in sql server, but want to add a extra column full of zeros</p>
  
  <p>What would be the best approach to do this</p>
  
  <pre><code>att1 att2
  ---------
  1.0   5.8
  2.7   3.8
  5.1   6.8
  </code></pre>
  
  <p>becomes</p>
  
  <pre><code>att1 att2  extra
  ----------------
  1.0   5.8   0.0
  2.7   3.8   0.0
  5.1   6.8   0.0
  </code></pre>