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

How to Improve the performencs of SQL Server 2005 exclude stored Procedure and Indexes?

1961

What is difference between delete & truncate commands?

1019

Describe in brief sql server monitoring ways.

999

What is difference between table aliases and column aliases? Do they affect performance?

909

What is a trace frag? Where do we use it?

1043

Disadvantages of the indexes?

1041

How to recreate an existing index in ms sql server?

984

What is the purpose of data source?

954

How to filter out duplications in the returning rows in ms sql server?

1064

What do you understand by mirroring and mention the advantages of the mirroring?

1008

What is wide table?

881

What are two difference between sql azure and azure tables?

159

Explain data warehousing in sql server?

988

What is a collation?

1032

What does it mean to be in union?

870