How To Change Column Ordinal Position in SQL Server 2005 using Query i.e

Advertise your Business Here

Refer this Site

Login | Sign Up


	Do you have a collection of Interview Questions and interested to share with us!! Please send that collection to along with your userid / name. ThanQ

Categories >> Software >> Databases >> SQL Server

Oracle Interview Questions

SQL Server Interview Questions

MS Access Interview Questions

MySQL Interview Questions

Postgre Interview Questions

Sybase Interview Questions

DB Architecture Interview Questions

DB Administration Interview Questions

DB Development Interview Questions

SQL PLSQL Interview Questions

Databases AllOther Interview Questions

Question

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 Submitted By :: Dinesh Sharma

I also faced this Question!!

Rank

Answer Posted By

Re: 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

Answer
# 1

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

4 No

Soorai Ganesh

Re: 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

Answer
# 2

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 ?

3 Yes

0 No

Bruhaspathy

Question	Asked @	Answers
Other SQL Server Interview Questions


What is INTVAL( )and where we use Plz any body help me		1
wat will be the sql query to extract only last 3 records from table supose table hving thousands for records		16
Difference between Cluster and Non-cluster index?	Oracle	9
how to know description of a table in sqlserver 2000		7
Which virtual table does a trigger use?	TCS	6
What meant by Performance Tuning,how can we do the performance tuning on stored procedures and tell some steps to do the performance tuning	TCS	2
Explain basic SQL queries with SELECT from where Order By, Group By-Having?	Wipro	2
We create an index to fast the search. How it fast the query? Do we write any special keyword with query?		3
Which institute is best for SQL Server 2005 Training?		5
what is difference between nchar and char in Sql server ?		2
how to implement locking in sql server	Satyam	1
Please tell me some knowledge about Clustering and how to add clustering?		1
What is Covering Indexes? Plz explain with example		2
What are explicit and implicit transactions?		2
How will oyu test the stored procedure taking two parameters namely first name and last name returning full name?		3
How are SQL Server databases physically stored under Windows 2000?		1
How to create logins using windows Authentication mode?		2
How can we write or define DDL statements in Sql server and DML statements?		2
which one will take 1st priority in case of insert statement and select statement???		2
what are three different authentications to connect linked servers?	CitiGroup	1

For more SQL Server Interview Questions Click Here


Copyright Policy \| Terms of Service \| Help \| Site Map 1 \| Articles \| Site Map \| Site Map \| Contact Us \|

Copyright © 2007 ALLInterview.com. All Rights Reserved.

ALLInterview.com :: Forum9.com :: KalAajKal.com