title: SQL Server 2008 R2 Add column into a specific location
body: <p>I am using SQL Server 2008 R2 and I wish to add a new column into a specific spot in the column order in a table and not at the end.   I wish to avoid having to recreate the table.  How do I do this without recreating the table?</p>
  
  <p>i.e.</p>
  
  <pre><code>Table: Bob
  ==========
     Col1
     Col2
  </code></pre>
  
  <p>Add new Column.</p>
  
  <pre><code>Table: Bob
  ==========
     Col1
     NewCol
     Col2
  </code></pre>