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
- 9500 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 is awe?
you want to be sure that queries in a database always execute at the maximum possible speed. To achieve this goal you have created various indexes on tables which other statement will keep the database in good condition? : Sql server administration
What Is Rdbms?
Which database stores information about replication?
Explain why variables called the most powerful component of ssis?
What are page splits?
How do you rename a table in sql server?
How to identify current user in ssrs report?
1 01 101 01010
write an SQL query to list the employees who joined in the month of January?
Explain about system stored procedure?
What is difference between aggregate and analytic function?
What is the importance of a recovery model?
Explain four layers of abstraction microsoft architectured?
Explain the difference between control flow and data flow?
