A paging sp from aspnetpager

CREATE procedure wqnews_GetPagedWQNews
(@ Pagesize int,
@ Pageindex int,
@ Docount bit)
As
Set nocount on
If (@ docount = 1)
Select count (newsid) from wqnews
Else
Begin
Declare @ indextable table (id int identity (1, 1), nid int)
Declare @ PageLowerBound int
Declare @ PageUpperBound int
Set @ PageLowerBound = (@ pageindex-1) * @ pagesize
Set @ PageUpperBound = @ PageLowerBound + @ pagesize
Set rowcount @ PageUpperBound
Insert into @ indextable (nid) select newsid from wqnews order by addtime desc
Select O. newsid, O. source, O. heading, O. addtime from wqnews O, @ indextable t where O. newsid = t. nid
And t. id> @ PageLowerBound and t. id <= @ PageUpperBound order by t. id
End
Set nocount off
GO