SQL ----存储过程分页

CREATE PROC GetCustomersByPage
@PageSize int,   ----页大小
@PageNumber int   ----页码
AS
Declare @RowStart int
Declare @RowEnd int
if @PageNumber > 0
 Begin
  SET @PageNumber = @PageNumber -1
  SET @RowStart = @PageSize * @PageNumber + 1;
  SET @RowEnd = @RowStart + @PageSize - 1 ;
  With Cust AS (
  SELECT FID, FName,
  ROW_NUMBER() OVER (order by FID) as RowNumber
  FROM T_Customer )
  select * from Cust Where RowNumber >= @RowStart and RowNumber <= @RowEnd
 END

 

select * From T_Customer Order by FID asc

exec GetCustomersByPage 20,5