returning data in blocks | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

returning data in blocks

What we want to do is have a query that returns data in sets of 20 rows – like when u do a google search- you get x number of results on the first page, click next page and get the next lot of results. The idea is to improve the speed of one of the searches in an application by not returning data that might not be needed. Does anyone have any suggestions as to how to go about implementing this kind of system? Thanks!
In generic terms, I feel how about defining the rowcount during the execution of script using SET ROWCOUNT option. Satya SKJ
This posting is provided “AS IS” with no rights for the sake of knowledge sharing.
Thanks Satya, but how would we go about returning the second 20 results??
It’s a classic question and different solutions exist. Here is one example: