Declare @ColumnName Varchar(50) Select @ColumnName = Name From syscolumns

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

Question Posted / k m rajesh

2 Answers
5709 Views
I also Faced
E-Mail Answers

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

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

Describe triggers features and limitations?

936

List out a number of the wants to setup a SQL Server failover cluster?

1012

How do I view a trc file?

905

Can coalesce return null?

952

What is a periodical index?

876

What are the difference between “where” and “having” clause in sql server?

1011

How will you make an attribute not process? : sql server analysis services, ssas

1021

Explain query editor regions

1009

What are distributed partitioned views?

1013

How does a profiler work?

880

Explain a join?

1015

what are the three command line utilities and what are their primary functions?

138

What are the default system databases in sql server 2000?

970

How to change parameter value inside the report?

156

How you can add messages to the nt event log from within a stored procedure?

1006