How to display n-1 columns from n number of columns, from a
single table in MS SQL server 2005?
- 2 Answers
- 5310 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
How to create a view using data from another view?
What is normalization? Explain different forms of normalization?
List the different index configurations possible for a table?
What is an indexing strategy?
Explain linked server in sql?
How to use "if ... Else if ... Else ..." Statement structures in ms sql server?
How to grant a permission in ms sql server using "grant execute" statements?
What is the difference between cube operator and rollup operator? : SQL Server Architecture
Can a table be moved to different filegroup?
What does asynchronous call backs means?
What are the different ways you can create databases in sql server?
What is the security model used in sql server 2005?
What is enhanced database mirroring in sql server 2008?
What is Cross Join and in which scenario do we use Cross Join?
When would you use sql joins?
