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
5695 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

What causes index fragmentation?

936

What are the types of indexing?

1029

What method is used by the Command classes to execute SQL statements that return single values?

1004

What are the Advantages of using CTE in sql server?

1041

What purpose does the model database server?

1054

What is ms sql server service broker?

932

What are the advantages of paper records?

907

Explain in details security in SQL azure?

121

What programming language would you use to create embedded functions in ssrs?

172

Explain ranking functions?

991

How to list all objects in a given schema?

985

What is identity?

948

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

136

Explain how to use linked server?

926

Explain about nested stored procedure?

976