--How custom paging Sp works
alter proc finalproc --0,10
@pageindex int,
@pagesize int
as
begin
select id,name,age,sex
from
(
select row_number() over (order by id) as row,id,name,age,sex from finaltable1
)temp
where row >= (@pageindex + 1) and row <= ((@pageindex + 1)*@pagesize)
end
alter proc finalproc --0,10
@pageindex int,
@pagesize int
as
begin
select id,name,age,sex
from
(
select row_number() over (order by id) as row,id,name,age,sex from finaltable1
)temp
where row >= (@pageindex + 1) and row <= ((@pageindex + 1)*@pagesize)
end
Hello, my name is Jack Sparrow. I'm a 50 year old self-employed Pirate from the Caribbean.
No comments:
Post a Comment