CREATE proc pageSelect (@pageSize int, @pageStart int, @total int output)
as
declare @i int
declare @pageNo int
if @pageStart=0
@pageNo=1
set @i=((@pageNo-1)*@pageSize)
exec('select top '+@pageSize+' * from person where id not in (select top '+@i+' id from person) ')
select @total=count(*) from person
GO