Efficiently Paging Through Large Amounts of Data

Get Sql Records With Row Index
***********************************

You can reduce your record traffic between process

DECLARE @start INT SET @start=2
DECLARE @end INT SET @end=3

SELECT us.UserID
FROM (SELECT ROW_NUMBER() OVER (ORDER BY UserID) AS Row, UserID
     FROM Users.[User]) us
WHERE Row > @start AND Row <= (@start + @end)