Select Top(5) COLUMN_NAME from INFORMATION_SCHEMA.COLUMNS Where TABLE

How to select top 5 coloumn from a table without using
coloumn name

Question Posted / dj

Answer Posted / dj

Select Top(5) COLUMN_NAME
from INFORMATION_SCHEMA.COLUMNS
Where TABLE_NAME = 'Emp';

Is This Answer Correct ?

1 Yes

0 No

Please Help Members By Posting Answers For Below Questions

What are the database objects? : SQL Server Architecture

718

What is a Join and explain its types?

828

What is the function of sql server agent windows service?

771

How can you stop stored procedures from recompiling?

656

Is sql different from sql server?

704

How to create indexed view?

744

How to disable a login name in ms sql server?

771

How to change the data type of an existing column with "alter table" statements in ms sql server?

742

Does sql server use t sql?

736

What are sql server procedures?

749

How many databases instances are there in sql server 2000?

771

What is dbcc command in sql server?

790

What is the sql case statement used for? Explain with an example?

733

Determine when an index is appropriate?

771

what is blocking? : Sql server database administration

741