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..........

Are semicolons required at the end of sql statements in sql server 2005?

0 Answers  

---

How do you create a clustered index?

0 Answers  

---

Explain difference between cross join and full outer join?

0 Answers  

---

What are the different types of indexes?

0 Answers   Blue Star,

---

Hi Can any one tell me the Good institute to learn SQL esp for Data Base Testing or SQL from scratch to the proficiency level in Hyederabad and facult also. Thankyou well in advance

6 Answers  

---

what operator performs pattern matching?

2 Answers  

---

How to delete duplicate records based on single column from a table?

0 Answers   Petranics Solutions,

---

Which tcp/ip port does sql server run on? How can it be changed?

0 Answers  

---

explain different levels of normalization? : Sql server database administration

0 Answers  

---

Where are stored procedures in sql server?

0 Answers  

---

PC(code, model, speed, ram, hd, cd, price) Find the hard drive sizes that are equal among two or more PCs.

6 Answers   APX,

---

how to delete duplicate rows from table in sql server

12 Answers   HCL, UHG,

---