SQLServer2005 row_number() 分页存储过程

create procedure [dbo].[GetProductByCategoryId](    @CategoryID int,    @PageIndex int = 0,    @PageSize int = 20,    @TotalRecords int output)asbegin   declare @ResultTable table(    RowIndex int,    ProductID int,    ProductName nvarchar(50),    CategoryID int,    Unit nvarchar(10),    UnitPrice money,    Quantity int);   insert into @ResultTableselect row_number() over (order by ProductID asc) as RowIndex,       p.ProductID, p.ProductName, p.CategoryID, p.Unit, p.UnitPrice, p.Quantityfrom   Products as pwhere CategoryID = @CategoryID;     select  @TotalRecords = count(*) from  @ResultTable;   select *from   @ResultTablewhere  RowIndex > (@PageSize * @PageIndex) and RowIndex <= (@PageSize * (@PageIndex+1));   end;