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
- 5713 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
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 |
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 |
What is the difference between the application object and session object?
What is the disadvantages of index?
Explain cursor as data base object?
What are sql dirty pages?
What is policy based management (pbm)? : sql server database administration
What is Index ? Explain its Types?
Can you link only other SQL Servers or any database servers such as Oracle?
can anyone explain me the concept of Serialization in Detail and Clear? plz its urgent i have interview on friday (15th feb)
Where the sql logs gets stored? : sql server database administration
If i am handling 150 servers then how to check the active jobs of all the servers?
How to determine the service pack currently installed on SQL Server?
How to find the second highest salary of an employee?
-
Oracle (3259) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3330)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1411)
- Databases AllOther (288)
