title: SQL Server: ALTER with ADD new column
body: <p>I have the following statement in SQL Server:</p>
  
  <pre><code>ALTER TABLE [dbo].[TruckTbl] 
  ADD [TruckState] [bit] NULL DEFAULT 0;
  </code></pre>
  
  <p>What this will do is to default any NEW record to 0.</p>
  
  <p>For existing records how can I get and say in the statement also default those to 0.</p>
  
  <p>I know I can go and do an update but anyway to do within an update in the <code>ALTER</code> statement above?</p>