10:54 AM
Unknown
This query will help you in doing paging through SQL Server. You will need to pass just the starting and ending index and it will return the records..
DECLARE @startingindex int;
DECLARE @endingindex int
set @startingindex=10
set @endingindex=20
select * from Table_Name
where table_id in(
SELECT us.table_id
FROM (SELECT ROW_NUMBER() OVER (ORDER BY table_id) AS Row,
Table_id
FROM Table_Name) us
WHERE Row >@startingindex and Row<@endingindex
)
Posted in
