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
- 5815 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 drop an existing table?
How to use group functions in the select clause in ms sql server?
Does order by actually change the order of the data in the tables or does it just change the output?
What is sql server used for?
What is table join?
What is normalization according to you and explain its different levels?
Explain activity monitors
What are the advantages dts has over bcp?
Which sql server table is used to hold the stored procedure script?
What is difference between temp table and cte?
How to delete an existing database user?
What purpose does the model database server?
why would you use sql agent? : Sql server database administration
Explain alternate key, candidate key and composite key in sql server?
What is the recovery model?
