Interested to Buy Any Domain ? << Click Here >> for more details...
How to select top 5 coloumn from a table without using
coloumn name
- 5 Answers
- 7662 Views
- I also Faced
- E-Mail Answers
Answer Posted / aashish arora
SELECT top 5 * from information_schema.columns where
table_name = 'varTableName'
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
What is ssrs?
What stored procedure would you use to view lock information?
What are the tool windows in sql server management studio? : sql server management studio
What is user-defined multi-statement table-valued function?
What is sql server query analyzer?
define and explain the differences between clustered and non-clustered indexes.
What is the difference between seek predicate and predicate?
What is a data source file?
You have a stored procedure, which execute a lengthy batch job. This stored procedure is called from a trigger you do not want to slow the data entry process you do not want trigger to wait for this batch job to finish before it completes itself what you can do to speed up the process?
what is the main function of a query parameter?
Why I can not enter 0.001 second in date and time literals in ms sql server?
You are designing a strategy for synchronizing an SQL Azure database and multiple remote Microsoft SQL Server 2008 databases. The SQL Azure database contains many tables that have circular foreign key relationships?
What is the difference between TRUNCATE and DROP?
What is cursor in ms sql server?
Explain the properties of sub-query in sql server?
