you
can not add column between two column in
sql server
when you add column it will added at last position by-default
drop table and recreate it if column position is important
but in select statement you can arrange columns
also in insert statement too, if you have write insert query like this
insert into tbl(Columns' list) values(value list)
not like this
insert into tbl select 1 as col1,...
Happy Coding!
:)