How to page recordset in Sql server?

[mooniron]

I want to show recordset as paged. I mean for instance: if I have 50 records and I want to show 10 of them per page. If anybody help me thanks to him/her....

 

[tlbroadbent]

What is your client software? Which version of SQL Server are you running? How do you connect to the server? The following articles may help. If not please provide more information.

Managing Result Set Paging

http://www.microsoft.com/sql/techinfo/tips/administration/resultset.asp

Paging: Use ADO, getrows, or a Stored Procedure?

http://www.15seconds.com/issue/010308.htm

Paging through Records using a Stored Procedure

http://www.aspfaqs.com/webtech/062899-1.shtml

Terry L. Broadbent - DBA
SQL Server Page:

http://tlbroadbent.home.attbi.com/sql/sql_articles.htm

If you want to get the best answer for your question read faq183-874.