.net(C#)求一个MSsql分页的存储过程

CREATE procedure pageer_rnewlist
(@pagesize int,
@pageindex int,
@docount bit,
)
as

set nocount on
if(@docount=1)

select count(*) from userinfo

else
begin

declare @indextable table(id int identity(1,1),ID int)
declare @PageLowerBound int
declare @PageUpperBound int
set @PageLowerBound=(@pageindex-1)*@pagesize
set @PageUpperBound=@PageLowerBound+@pagesize
set rowcount @PageUpperBound

insert into @indextable(ID)
select ID from useinfo where order by ID desc

select O.* from userinfo O,@indextable t where O.ID=t.ID
and t.ID>@PageLowerBound and t.ID<=@PageUpperBound order by t.ID

end
set nocount off