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
- 9495 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
Explain primary key, foreign key and unique key?
How can you find out which stored procedures are recompiling?
How do I find the port number for sql server?
How to stop a loop early with break statements in ms sql server?
Explain the usage of floor function in sql server.
What are system databases into sql server (2005/2008)?
Tell me what are the advantages of using stored procedures?
Do you think BCNF is better than 2NF & 3NF? Why?
Define master database?
How do we Backup SQL Azure Data?
What is ms sql server triggers?
What is tablix?
Which joins are sql server default?
How to attach adventureworkslt physical files to the server?
Explain the third normal form(3nf)?
