title: How to ALTER multiple columns at once in SQL Server
body: <p>I need to <code>ALTER</code> the data types of several columns in a table.</p>
  
  <p>For a single column, the following works fine:</p>
  
  <pre><code>ALTER TABLE tblcommodityOHLC
  ALTER COLUMN
      CC_CommodityContractID NUMERIC(18,0) 
  </code></pre>
  
  <p>But how do I alter multiple columns in one statement? The following does not work:</p>
  
  <pre><code>ALTER TABLE tblcommodityOHLC
  ALTER COLUMN
      CC_CommodityContractID NUMERIC(18,0), 
      CM_CommodityID NUMERIC(18,0)
  </code></pre>