How to select top 5 coloumn from a table without using
coloumn name
Answers were Sorted based on User's Feedback
Answer / aashish arora
SELECT top 5 * from information_schema.columns where
table_name = 'varTableName'
Is This Answer Correct ? | 2 Yes | 0 No |
Answer / dj
Select Top(5) COLUMN_NAME
from INFORMATION_SCHEMA.COLUMNS
Where TABLE_NAME = 'Emp';
Is This Answer Correct ? | 1 Yes | 0 No |
how we use window authentication connection with sql server.?
Can you explain various data region available in ssrs with their use?
How to rename an existing table with the "sp_rename" stored procedure in ms sql server?
How do I list the available tables in a database I'm querying?
How does index makes search faster?
What changes in the front end code is needed if mirroring is implemented for the high availability? : sql server database administration
What is the sql case statement used for? Explain with an example?
State the difference between local and global temporary tables?
What is the bookmark lookup and rid lookup?
What is the openxml statement in sql server?
what is nonclustered index
What happens if the update subquery returns multiple rows in ms sql server?