SQL分页

DECLARE @sUserNo NVARCHAR(20)

,@sBillNo NVARCHAR(50)

,@sStartDate DATETIME

,@sEndDate DATETIME

,@iPageSize INT = 20

,@iPageIndex INT = 1;

IF ISNULL(@iPageIndex,0) < 1

SET @iPageIndex = 1 ;

iF ISNULL(@iPageSize,0)<1

SET @iPageSize = 50 ;

SET @sEndDate = @sEndDate + 1

SELECT a.sBillNo FROM   dbo.sdGmtOrderHdr A (NOLOCK)  ORDER BY a.sBillNo DESC

OFFSET (@iPageIndex - 1) * @iPageSize ROW FETCH NEXT @iPageSize ROWS ONLY;