SQL paging stored procedure with jquery paging control

ALTER PROCEDURE [dbo]. [GetData]
--Add The parameters for the stored procedure here
@tb varchar (150),
@status nchar (2),
@indexpage int,
@endpage int
As
DECLARE @str varchar (200)
If @status is null
BEGIN

Set @str = ' SELECT * FROM (select Row_number () over (order by t.id Desc) as ROW, t.* from ' [email protected]+ ' T where Status = ' [email protected]+ '] TT WHERE TT. Row between ' +str (@indexpage) + ' and ' +str (@endpage)
EXEC (@str)
END
Else
BEGIN
Set @str = ' SELECT * FROM (select Row_number () over (order by t.id Desc) as ROW, t.* from ' [email protected]+ ' t) TT WHERE T T.row between ' +str (@indexpage) + ' and ' +str (@endpage)
EXEC (@str)
END

SQL paging stored procedure with jquery paging control