HI.
Why would you want to do such a thing?
In SQL Server you cannot add a column at a specific location. You should play dirty with Management Studio (but it's not always possible) or by creating a new table and moving the data into it.
However, in general I advise against doing this. You simply create a view that gives you the columns in the order you want.