MS SQL.Function-Pageing 처리 예제

[ MS SQL.Function-Pageing 처리 예제 ]

CREATE FUNCTION GetAddressPage(@Page INT, @PageSize INT) RETURNS TABLE AS RETURN WITH OrderedAddress AS ( SELECT ROW_NUMBER() OVER (ORDER BY code) AS 'RowNumber' , A.* FROM ( SELECT code , sd +' '+gg+' '+dong AS 주소 FROM TBL_WFORECAST_DONGLIST WHERE gg!='' AND dong !='' ) AS A ) SELECT * FROM OrderedAddress WHERE RowNumber BETWEEN (@Page - 1) * @PageSize + 1 AND (@Page * @PageSize);