How To Change Column Ordinal Position in SQL Server 2005
using Query i.e I Want To Add Column at Particular Ordinal
Position in SQL Server 2005
Answer Posted / 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..........
Is This Answer Correct ? | 0 Yes | 6 No |
Post New Answer View All Answers
Please explain what is “asynchronous” communication in sql server service broker?
Explain unique key in sql server?
What is database replication? What are the different types of replication you can set up in sql server?
Where to find ntwdblib.dll version 2000.80.194.0?
What is order of B+tree?
How will you optimize a stored procedure optimization?
What is the cartesian product of table?
What to perform pattern match with the like operator?
What is the meaning of lock escalation and why/how to stop this? : sql server database administration
What is sub-query in sql server? Explain its properties.
What is the use of @@spid?
What are the differences in Clustering in SQL Server 2005 and 2008 or 2008 R2?
Explain the properties of subqueries in sql server?
How to convert numeric values to integers in ms sql server?
What is the difference between set and select?