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 ?

2 Yes

3 No

Please Help Members By Posting Answers For Below Questions

What are distinctive joins find as a part of sql?

1000

What is a subquery in a select query statement in ms sql server?

1184

Explain the characteristics of a transaction server for example atomicity, consistency, isolation, durability?

1175

When is the use of update_statistics command?

1055

How can you find out which stored procedures are recompiling?

948

what method you can use to reduce the overhead of Reporting Services data sources?

268

How global temporary tables are represented and its scope?

1011

Explain transaction isolation levels in sql server?

1178

How can you hide the sql server instances?

1063

What is the default sql server instance name?

1081

What is 3nf normalization?

1046

How many categories of data types used by sql server?

1051

Explain aggregate functions?

1135

Mention what are the different types of ssrs reports?

158

What is the difference between MVC and Teir Architecher? Plz explain with Layyered Programming example...? Thanks

2130