how to retuen parameter in SP with index and Pagesize 10

Question

user can exec 5,10

that time disply record of 51 To 63 using Stored Procedure

 

 

CREATE PROCEDURE dbo.spGetEmployees

(

@StartRow INT = 1,

@RowCount INT = 10

)

AS

BEGIN

               // logic

 

END 

exec dbo.spGetEmployees(5) 

out put will be 51 To 63 Record display