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

How do you create a data source?

0 Answers  

---

employee table has employee id ----------- empid ---------------- 1 2 3 3 3 4 5 5 5 6 6 6 7 here the values r repeated two times.how to select the repeated values only.i.e 3,5,6 should alone come.

3 Answers  

---

How many database files are there in sql server 2000?what are they?

0 Answers  

---

diffrence between Cluster Index and non Cluster Index

3 Answers   Wipro,

---

What are the purpose of Normalisation?

0 Answers   HCL,

---

---

What is the default port for SQL Server over a firewall?

0 Answers   Microsoft,

---

write the query for find the top 2 highest salary in sql server

36 Answers   Cranes, Jayanti Software, Medi Assist, Rmax, TCS,

---

What is a Linked Server?

1 Answers  

---

can we call functions from stored procedure in SQL Server 2005 ? How?

3 Answers  

---

What is unpivot?

0 Answers  

---

When should you use an instead of trigger?

0 Answers  

---

please tell me the query to get details of the employee having the second largest salary

11 Answers   247Customer,

---