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
- 7735 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
Which data types generate inaccurate results if used with an = or <> comparison in a where clause of a sql statement?
What is a virtual table in sql?
What are the types of sql server?
Explain how does the report manager work in ssrs?
Will count(column) include columns with null values in its count?
You have modified 100 store procedures and want to replicate these changes from development to prodution, and production can have users using the Server/DB, how would you replicate without causing issues?
How to Check if table exists in sql server?
What is an indexed view?
What is the use of sql profiler in sql server 2012?
What is save transaction and save point?
Explain what are the database objects? : SQL Server Architecture
Is it possible for a stored procedure to call itself or recursive stored procedure? How many levels of sp nesting are possible?
When a primary key constraint is included in a table, what other constraints does this imply?
What is data source object?
Which are the third-party tools used in sql server and why would you use them?
