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
- 9307 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
please differentiate between delete and truncate?
you have developed an application which uses many stored procedures and triggers to update various tables users ocassionally get locking problems which tool is best suited to help you diagnose the problem? : Sql server administration
When should you use an instead of trigger?
Explain logical operators in sql server?
What is extended stored procedures?
How can I check that whether automatic statistic update is enabled or not?
Define synonym?
What is scheduled job and how to create it?
How will you hide an attribute? : sql server analysis services, ssas
what stored procedure can you use to display the current processes? : Sql server administration
What are the basic functions for master, msdb, model, tempdb and resource databases? : SQL Server Architecture
Is it possible for a stored procedure to call itself or recursive stored procedure?
what is a live lock? : Sql server database administration
What is query cost in sql server?
What is the default schema of your login session in ms sql server?
