title: how to add a column at a specific position in a table?
body: <blockquote>
    <p><strong>Possible Duplicate:</strong><br>
    <a href="https://stackoverflow.com/questions/6121884/sql-server-2008-cannot-insert-new-column-in-the-middle-position-and-change-dat">SQL Server 2008 : Cannot Insert new column in the middle position and change data type</a>  </p>
  </blockquote>
  
  
  
  <p>Hi i am using SQL SERVER 2008 &amp; 2008 R2 i would like to add a column in a table at a specific position using alter command. is there any way keyword using which we can add a column at a specific position ? thanks! in adavanced.</p>