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
- 9308 Views
- I also Faced
- E-Mail Answers
Answer Posted / 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.
| Is This Answer Correct ? | 6 Yes | 0 No |
Post New Answer View All Answers
How to apply filtering criteria at group level with the having clause in ms sql server?
What is an etl file?
How to test subquery results with the exists operator?
What new changes are being made in SQL Server?
Why is sql server log file full?
How to modify an existing user defined function?
How many tables can be joined in SQL Server?
How to insert data into an existing table?
What are cursors in ms sql server?
How to use wildcard characters in like operations in ms sql server?
Where sql server usernames and passwords are stored in a sql server?
Explain what is row_number function?
How do I install only the client tools of sql server 2000?
What is always encrypted?
Do you know how to make remote connection in database?
