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
- 9420 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 can I create a report based on a query? : sql server management studio
Explain alternate key, candidate key and composite key in sql server?
How can delete duplicate records in cte in sql server?
What is the need for group functions in sql?
What is the boxing and unboxing concept in .net?
what is a self join? Explain it with an example? : Sql server database administration
What are the types of subscriptions in SQL Server replication?
Explain various data region available in ssrs with their use?
Which table keeps the locking information?
what’s the difference between Covering Indexes and Clustered Indexes ? how to use clustered index small ?
Different types of keys in SQL?
What is the web service used for reporting services?
What are different types of raid configurations? : SQL Server Architecture
What is stored procedures?
IF more than one Site is accessing the same Database server and I want to move the DB with Minimum down time? How will you do
