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

How to create a stored procedure with a statement block in ms sql server?

1073

Define the one-to-one relationship while designing tables.

907

how to overcome kernel isssues

1629

What changes in the front end code is needed if mirroring is implemented for the high availability? : sql server database administration

1024

Can two tables have the same primary key?

1216

How to download and install sql server 2005 books online?

1195

What is temporal data type?

925

Tell me can we use custom code in ssrs?

1007

How to get the definition of a trigger back?

1002

What is store procedure?

1070

How to delete database objects with "drop" statements in ms sql server?

1093

What is service broker?

1008

What are horizontal and vertical scaling?

172

Can we call future method from trigger?

947

what is database replicaion? What are the different types of replication you can set up in sql server? : Sql server database administration

991