如何实现SQL Server 2005快速web分页

DECLARE @i SMALLINT
SET @i = 1

WHILE (@i <=100)
BEGIN     
      INSERT INTO SalesHistory     
      (Product, SaleDate, SalePrice)     
      VALUES     
('Computer', DATEADD(mm, @i, '3/11/1919'), DATEPART(ms, GETDATE()) + (@i + 57) )

      INSERT INTO SalesHistory     
      (Product, SaleDate, SalePrice)     
      VALUES     
('BigScreen', DATEADD(mm, @i, '3/11/1927'), DATEPART(ms, GETDATE()) + (@i + 13) )
     
      INSERT INTO SalesHistory     
      (Product, SaleDate, SalePrice)     
      VALUES     
('PoolTable', DATEADD(mm, @i, '3/11/1908'), DATEPART(ms, GETDATE()) + (@i + 29) )
     
      SET @i = @i + 1
END