How to get max 100 values from sql server

Answer Posted / veeresh kethari

set rowcount 100
select * from tablename

Is This Answer Correct ?    4 Yes 3 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Explain what is sql server english query?

530


but what if you have to create a database with two filegroups, one on drive c and the other on drive d with log on drive e with an initial size of 600 mb and with a growth factor of 15%? : Sql server database administration

525


How to attach adventureworkslt physical files to the server?

629


What does COMMIT command do?

624


What is the stuff?

524






What is the usage of the sign function?

526


Can I save my report as html, excel or word? : sql server management studio

541


How to convert numeric expression data types using the cast() function?

542


How to drop an existing stored procedure in ms sql server?

540


you added a row to a view, but the row is not shown on the view. Explain how this can happen, and how you can remedy the situation

535


What function does a database engine serve in the sql server?

569


What is an index. What are the types?

582


What is xml datatype?

649


What is difference between drop truncate and delete?

545


Sql server reporting services vs. Crystal reports.

96