title: How to insert columns in between in table in sql server 2008
body: <p>I want to add or update columns using alter table if i am adding a new column i want show error. I am using the code below</p>
  
  <pre><code> alter table Personal_Details alter columns DOB datetime 
  </code></pre>
  
  <p>if i uncheck the NULL to not NULL then it will shows column does not allow nulls; update fails;</p>
  
  <p>i want to insert the fields in between columns not at end.</p>
  
  <p>Plese fix my bug,</p>
  
  <p>Thanks in advance.</p>