Answer / bruhaspathy

You cannot add a column at that particular position that you wanted. Instead the workaround is that you add the column using the Alter Table command and then after the columns are created, you can go to object explorer and right click the table, select modify and then move the column to the desired column location you wanted.

Answer / soorai ganesh

Hi Buddy,

Its not possible in SQLSERVER. If u want to add column in
particular ordinal position you have to drop the table and
have to create again the same table with your ordinal
choice. Incase if u have data in table, get them into one
temporary table and drop the table and recreate the table
again. then restore the data from temporary table..........

Do you know query execution plan?

1 Answers  

---

how to copy only distinct data into another table which is not already exist in database?

2 Answers   Spectra,

---

How to create a simple stored procedure in ms sql server?

1 Answers  

---

Difference between server.transfer and server.execute method?

2 Answers  

---

sql server syntax to add "!" sign to "name" field of "employee" table in a manner that all names have the same lenght of 20 characters

1 Answers  

---

List out the difference between union and union all in sql server?

1 Answers  

---

What are the types of database recovery models?

1 Answers   HCL,

---

how to improve the speed of SQL database server and how to avoid dead lock?

1 Answers   TCS,

---

How do you implement session management in SQL Server mode?

1 Answers   Cap Gemini,

---

Do you know what are the properties of the relational tables?

1 Answers  

---

how can a database be repaired? : Sql server administration

1 Answers  

---

What are the main sources of data?

1 Answers  

---