写了个简单的数据分页 存储过程

ALTER proc sp_index @currPage int,@pageSize int,@num int outputasbegin--总数据量declare @strTmp nvarchar(500)declare @result intset @result=(select count(id) from mostData)if(@result % @pageSize >0)beginset @num=@result/@pageSize +1;endelsebeginset @num=@result/@pageSize ;end--if(@currPage>@num)beginreturn 0;endelsebeginif(@currPage=1)beginset @strTmp='select top('+Convert(nvarchar(40),@pageSize)+') * from mostData order by id asc'endelsebeginset @strTmp='select top('+Convert(nvarchar(40),@pageSize)+') * from mostData where id not in(select top('+Convert(nvarchar(40),@pageSize*(@currPage-1))+') id from mostData order by id asc) order by id asc'endendexec(@strTmp)--select @strTmpend