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 display n-1 columns from n number of columns, from a
single table in MS SQL server 2005?

Question Posted / kaumil2001

Answers were Sorted based on User's Feedback



How to display n-1 columns from n number of columns, from a single table in MS SQL server 2005?..

Answer / k m rajesh

Declare @ColumnName Varchar(50)
Select @ColumnName = Name From syscolumns Where id = object_id(Table_Name) and ColID = (Select Count(name)-1 from SysColumns Where id = object_id(Table_Name))

Is This Answer Correct ?    0 Yes 0 No

How to display n-1 columns from n number of columns, from a single table in MS SQL server 2005?..

Answer / rajesh ranjan

Declare @ColumnName varchar(50)
select @ColumnName=Name from syscolumns where id=object_id
(Table_Name) and colid=1 --2 for second Column, 3 for third
exec ('select '+@ColumnName+' from Table_Name')

Is This Answer Correct ?    1 Yes 2 No

Post New Answer

More SQL Server Interview Questions

What is the maximum length of an alert name?

0 Answers  

Do you know what is openxml in sql server?

0 Answers  

How to get the definition of a stored procedure back?

0 Answers  

what is curser.

9 Answers  

What is scalar user-defined function?

0 Answers  

What types of integrity are enforced by a foreign-key constraint

1 Answers  

how to find 6th highest salary

0 Answers   Chetak Logistics,

wat is the main diff between sql server 2000and sql server 2005

6 Answers   Jade Software,

What are the database roles? : sql server security

0 Answers  

wat is tuff file in log shipping, wt is d use of tht file?

1 Answers   TCS,

What is ddl command?

0 Answers  

Accidentally i deleted my table. How can i get that table?

4 Answers  

For more SQL Server Interview Questions Click Here
Categories