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

Do you know what is sql service broker?

997

as a part of your job, what are the dbcc commands that you commonly use for database maintenance? : Sql server database administration

860

What are the different types of backups avaialabe in sql server 2005?

972

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

1047

write an SQL query to list the employees who joined in the month of January?

1624

How to convert a table data in XML format in sql server?

2495

What is field in algebra?

983

How to enable tcp/ip protocol on a sql server?

1094

Explain optimistic and pessimistic concurrency?

930

What are partitioned views?

940

What is SQL Azure Firewall?

134

What is a view in sql?

929

What are information schema views?

924

How can you list all the columns in a database?

887

How do we upgrade from SQL Server 6.5 to 7.0 and 7.0 to 2000?

1948