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

What is report snapshot in ssrs?

247

How do you check sql server is up and running?

935

When is the use of update_statistics command?

953

What are logical database components? : SQL Server Architecture

962

What is the default Port No on which SQL Server listens?

1071

What is 5nf in normalization form?

936

What are the different types of replication are there in sql server 2000?

984

What is the importance of three tier architecture?

1026

How do you set a trace flag in sql server?

998

How to sort the query output with order by clauses in ms sql server?

984

explain the difference between oracle- sql and sql server sql ? if both are same y we r using 2 sw.s?

2426

How many types of triggers in sql server?

972

What is the significance of null value and why should we avoid permitting null values?

918

What is the recovery model?

932

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

1008