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 is hierarchy, what are its types and difference between them? : sql server analysis services, ssas

1243

What are the basic functions for master, msdb, model, tempdb databases?

1026

What is triggers in ms sql server?

1096

What is partitioned view?

888

Is it possible to update the views? If yes, how, if not, why?

1010

What is a filestream?

974

what are statistics, under what circumstances they go out of date, how do you update them? : Sql server database administration

933

What is query optimization process?

991

Explain boyce and codd normal form(bcnf)?

924

What is join query?

873

What are the elements of dbms?

951

what are acid properties? : Sql server database administration

977

Can a table be created inside a trigger?

956

What is a schema in ms sql server 2005?

952

Tell me what do we need queues in sql service broker?

973