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
- 9403 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 the preferred way to create a clustered and non-clustered index? Which index should you create first the clustered or non-clustered?
Explain what you mean by 3 tier architecture.
How can you fetch alternate records from a table?
If any stored procedure is encrypted, then can we see its definition in activity monitor?
Explain Normalization and DE normalization
What is the template in sql?
How to implement one-to-one, one-to-many and many-to-many relationships while designing tables?
What is fill factor and pad index?
What is a recursive stored procedure in sql server?
When columns are added to existing tables, what do they initially contain?
What is rolap and its advantage? : sql server analysis services, ssas
as a general practice, it is recommended to have dbo be the owner of all database objects however, in your database you find number of tables owned by a user other than dbo, how could you fix this? : Sql server administration
What is temporary table in sql server? Why we use temp table?
What is the xml datatype?
What is full outer join in sql server joins?
