An ASP. NET paging Stored Procedure

Alter procedure Pager
(
@ Pagesize int, -- number of lines per page
@ Pageindex int, -- current page number
@ Type int
)
As
Declare @ total int -- total number of rows
Declare @ totalpage int -- total number of pages
Select @ Total = count (*) from topic table where category = @ type -- total number of topics in the category of knowledge
 
Set @ totalpage = (@ total + @ pagesize-1)/@ pagesize; -- total number of pages = (total number of topics + number of lines per page-1)/number of lines per page
If (@ pageindex <= @ totalpage) -- if the current page is smaller than the total number of pages
Begin
Declare @ pagetable table (ID int identity (), pid int) -- create a temporary table
Insert into @ pagetable (PID)
Select ID from topic table where category = @ type order by posting time desc -- save the ID field of a topic table to a temporary table based on the posting time
Declare @ pagelower int -- upper limit of definition
Declare @ pageupper int -- defines the lower limit
Set @ pagelower = (@ pageindex-1) * @ pagesize + 1; -- for example, the number of lines per page is 10, the first page is from 1-10, and the second page is from 11-20
Set @ pageupper = @ pagelower + @ pagesize;

Select * From topic table where ID in
(Select PID from @ pagetable
Where ID >=@ pagelower and ID <@ pageupper) order by posting time DESC
End
Return @ totalpage;