ALTER PROCEDURE GetData
@pagesize INT,--10
@pagenum INT--2
AS
SELECT * FROM (
SELECT ROW_NUMBER() OVER (ORDER BY dbo.user_info.id)AS rowid,* FROM dbo.user_info
)AS t
WHERE t.rowid BETWEEN @pagenum*@pagesize+1 AND (@pagenum+1)*@pagesize
exec getdata 10,3