Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 2 Answers
- 9427 Views
- I also Faced
- E-Mail Answers
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
What are the different subsets of sql?
How to return the second 5 rows in ms sql server?
What is isnull() operator?
Can You Use Data Mining Models In Ssrs?
How to attach adventureworkslt physical files to the server?
What is the use of sql profiler in sql server 2012?
What is the standby server?
What is bulkcopy in sql?
What is the full meaning of dml?
Write a sql query to display the current date?
How to insert multiple rows with a subquery?
What are the purposes and advantages stored procedure?
What is a transactions?
Explain unique key in sql server?
What is store procedure? How do they work?
