consider the existing table Persons
Columns:Name,Age and City
I want to add new column between Name and Age as Email through t-SQL
select Name,cast(null as varchar(50)) as 'Email',Age,City into tempPersons from Persons
drop table Persons//drop existing table
exec sp_rename 'tempPersons','Persons'//rename the table