How to insert a column in between 2 columns of the table using alter statement.

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!
:)