No of rows to be displayed I have 100 records. I want to display only 10 rows of that record default or by specifying the number by using procedure
You can specify the number of records to return by using TOP

SELECT TOP 10 * FROM table