How to display n-1 columns from n number of columns, from a single table in MS

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

Question Posted / kaumil2001

2 Answers
5351 Views
I also Faced
E-Mail Answers

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