SQL 2005 에서 페이징 처리법
간단하게 잘 되었네요..
-- @CurrentPageIndex : 현재페이지번호 (1번부터시작)
-- @PagingSize : 한페이지에 표시할 게시글수
SELECT TOP (@PagingSize) *
FROM
(
SELECT ROW_NUMBER() OVER(ORDER BY AccountNo DESC) AS RowNo, *
FROM members
) A
WHERE A.RowNo > (@CurrentPageIndex - 1) * @PagingSize;
의문사항 ::
SELECT ROW_NUMBER() OVER(ORDER BY AccountNo DESC) AS RowNo, * FROM members 을
SELECT TOP( @CurrentPageIndex * (@PagingSize) ROW_NUMBER() OVER(ORDER BY AccountNo DESC) AS RowNo, * FROM members 로
바꾸면 어떻까 하는 생각이 든다...
