Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

  1. Categories >> Software >> Databases >> SQL Server
  2. Suggest New Category

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

Question Posted / dinesh sharma

Answers were Sorted based on User's Feedback



How To Change Column Ordinal Position in SQL Server 2005 using Query i.e I Want To Add Column at P..

Answer / 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

How To Change Column Ordinal Position in SQL Server 2005 using Query i.e I Want To Add Column at P..

Answer / 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

More SQL Server Interview Questions

What are the types of normalization?

0 Answers  

I Have Employee table having column name as ID,SALARY how to get second max salary from employee table with id ex ID SALARY 1 20000 7 37000 2 5000

17 Answers   HCL, IBM,

What are the results of running this script?

0 Answers  

How to fetch the next row from a cursor with a "fetch" statement?

0 Answers  

Name the different type of indexes in sql?

0 Answers  

What is xml datatype?

0 Answers  

What is bcp? When does it used?

0 Answers  

What is Inner Join?

2 Answers  

How to create and drop temp table in sql server?

0 Answers  

what is create database syntax? : Sql server database administration

0 Answers  

What are the new features introduced in SQL Server 2000 (or the latest release of SQL Server at the time of your interview)? What changed between the previous version of SQL Server and the current version?

0 Answers  

What is used to replicate sessions between instances in coldfusion clusters?

0 Answers   HCL,

For more SQL Server Interview Questions Click Here
Categories