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