SELECT top 5 * from information_schema.columns where table

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

Question Posted / aashish arora

Answer Posted / aashish arora

SELECT top 5 * from information_schema.columns where
table_name = 'varTableName'

Is This Answer Correct ?

2 Yes

0 No

Please Help Members By Posting Answers For Below Questions

What are the types of dml?

548

what is the difference between delete table and truncate table commands? : Sql server database administration

517

When cursors are useful?

573

Explain what is log shipping?

568

What is a benefit of using an after insert trigger over using a before insert trigger?

505

Explain transaction server auto commit?

531

What are group functions in query statements in ms sql server?

545

What is reference section?

494

What is meant by Active-Passive and Active-Active clustering setup?

550

How do I install only the client tools of sql server 2000?

543

How real and float literal values are rounded?

578

What do you know about system database? : SQL Server Architecture

484

what exactly sql injuction.how to overcome.....

2035

What is a fill factor?

614

What are the different acid properties?

620