Can we add a column in a specific position in sql server???

Ok. 

Thanks Vikrant.
 

i raised same question 2 year ago please refer link below,
http://stackoverflow.com/questions/12671629/how-to-add-a-column-at-a-specific-position-in-a-table

if you want to change column position any how; you can create view on it by specifying proper position of columns.

It can't be done in code unless you do essentially what SSMS is doing behind the scenes which is not a good idea IMO.

Does it really matter anyway what order the columns are actually in?

What does matter is that when you query the table you can return the columns in whatever order you like.

 

I have also read this.
So, it may be correct answer.

As per my study it wont possible in SQL Server using query.

Hello Vikrant,

        I don't want to do it graphically.

        I am looking the answer of this question by query.

In SQL Server it allow to add column at particular position using SQL Server Management Studio, right click on table and then design select the row where you want to add column right click Insert Column provide column name and data type you want then save it. If you are getting any error saving it; then you need to uncheck the column for "prevent saving changes that required table re-creation" setting,for this  select Tools -> Options -> Designers -> uncheck prevent saving changes that required table re-creation "by default its checked".