The paging of the stored procedure!!

Stored Procedures | Paging CREATE proc Up_gettopiclist
@a_strForumID varchar (50),
@a_intPageNo int,
@a_intPageSize int
As
/* Define Local Variables * *
DECLARE @intBeginID int
DECLARE @intEndID int
DECLARE @intRootRecordCount int
DECLARE @intPageCount int
DECLARE @intRowCount int
/* Close Count * *
SET NOCOUNT ON


/* Ask for a total number of root paste * *
Select @intRootRecordCount = count (*) from Bbs_topic where Fatherid=0 and forumid= @a_strForumID
if (@intRootRecordCount = 0)--returns zero if no posts
return 0

* To determine whether the number of pages is correct *
if (@a_intPageNo-1) * @a_intPageSize > @intRootRecordCount
Return (-1)

* * Ask to start rootid*/
Set @intRowCount = (@a_intPageNo-1) * @a_intPageSize + 1
/* Limit number of bars * *
SET ROWCOUNT @intRowCount
Select @intBeginID = Rootid from bbs_topic where fatherid=0 and forumid= @a_strForumID
ORDER BY tid Desc

/* End rootid*/
Set @intRowCount = @a_intPageNo * @a_intPageSize
/* Limit number of bars * *
SET ROWCOUNT @intRowCount
Select @intEndID = Rootid from bbs_topic where fatherid=0 and forumid= @a_strForumID
ORDER BY tid Desc

/* RESTORE SYSTEM Variable * *
SET ROWCOUNT 0
SET NOCOUNT OFF

Select A.tid, A.layer, A.forumid, A.subject, A.faceid, A.hits, A.posttime, A.userid, A.fatherid, A.rootid,
' Bytes ' = datalength (a.content), B.loginname, B.email, B.homepage, B.signature, B.point
From Bbs_topic as a join Bbs_user as B on a.userid = B.uid
where forumid= @a_strForumID and A.rootid between @intEndID and @intBeginID
ORDER BY A.rootid Desc, a.ordernum desc
return (@ @rowcount)
--select @ @rowcount
Go

How to operate is not pasted!! Take a good look, everybody.