Aspnetpager sql2000 Paging Stored procedures

ASP Tutorials Netpager sql2000 Paging stored procedures
The article is a collection of online information on the use of ASP.net tutorial pager and MSSQL Server 2000 data stored procedures paging code, very simple, we just transfer size into the page can be an example of OH.
*/

Create proc Pindex
(
@index int,
@size int,
@total int OUTPUT,
@pagecount int Output
)
As
Begin
declare @sqlstr nvarchar (1000)

Select @total =count (*) from star

if (@total% @size =0)
Set @pagecount = @total/@size
Else
Set @pagecount = @total/@size +1

if (@index =1)
Set @sqlstr = ' Select Top ' +str (@size) + ' * from Star '
Else
Set @sqlstr = ' Select Top ' +str (@size) + ' * from star where SID is not in (select Top ' +str (@size * (@index-1)) + ' SID from Star "

EXEC (@sqlstr)
End

EXEC pindex 2,5,0,0