viral patel

viral patel

  • NA
  • 327
  • 5.8k

how to retuen parameter in SP with index and Pagesize 10

Dec 14 2016 6:15 AM
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 
 
 
 
 
 
 
 
 

Answers (6)