Interested to Buy Any Domain ? << Click Here >> for more details...
How to display n-1 columns from n number of columns, from a
single table in MS SQL server 2005?
- 2 Answers
- 5799 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
Where the sql logs gets stored?
Is there any difference between primary key and unique with the not null condition?
What is the stored procedure?
what are different types of backups available in sql server? Given a particular scenario, how would you go about choosing a backup plan? : Sql server database administration
What are the parts of a function?
What is the maximum size of a row in sql server?
Why does a sql statement work correctly outside of a user-defined function, but incorrectly inside it?
In what version of sql server were synonyms released?
What are the restraints imposed on the table design by a merge replication?
Explain activity monitors
What is the process of normalising?
What is amo? : sql server analysis services, ssas
How do indexes help, types?
What is wrong with sql server client libarary dll, ntwdblib.dll?
What is replace and stuff function in sql server?
