set rowcount 100 select * from tablename

How to get max 100 values from sql server

Question Posted / veeresh kethari

Answer Posted / veeresh kethari

set rowcount 100
select * from tablename

Is This Answer Correct ?

4 Yes

3 No

Please Help Members By Posting Answers For Below Questions

Which tcp/ip port does the sql server run on? How can it be changed?

1049

What does REVERT do in SQL Server 2005?

949

What is blocking and how would you troubleshoot it? : sql server database administration

1039

New concepts of sql server 2005 use in your project.

2355

Is it ok to shrink transaction log?

990

System variable and temporary variables

2244

Which are the olap features?

951

How many tables can be joined in SQL Server?

1054

Where sql server user names and passwords are stored in sql server? : sql server database administration

1042

What are subquery and its properties?

1039

What is repeatable read?

1006

Explain contrast amongst grouped and non-bunched records?

1009

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

1059

I create a separate index on each column of a table. What are the advantages and disadvantages of this approach? : Sql server database administration

1080

Explain how you can deploy an SSRS report?

146