SQL Paging SP - 2000

CREATEPROC[dbo].[apProcedureName]

@PageRow INT,
@PageNo INT,

@TotalCount INTOUTPUT

AS

SET NOCOUNT ON

DECLARE @ColumnCount INT // 컬럼카운터용 변수

DECLARE @PageColumn INT // 페이지컬럼용 변수

// 페이징 처리를 위해 전체 데이터 건수를 가져온다.

SELECT @TotalCount =COUNT(A.ContentID)

FROM tblContent A WITH(NOLOCK)

JOIN tblMember B WITH(NOLOCK)ON B.MemberID =A.MemberID

SET @ColumnCount =((@PageNo-1)*@PageRow+1)

SET ROWCOUNT @ColumnCount

SELECT @PageColumn = A.ContentID
FROM tblContent A WITH(NOLOCK)
JOIN tblMember B WITH(NOLOCK)ON B.MemberID =A.MemberID
ORDERBY A.ContentID DESC

SET ROWCOUNT @PageRow

SELECT A.ContentID,

A.MemberID,

A.Content,

A.InsertDate,

B.UserID,

B.NickName
FROM tblContent A WITH(NOLOCK)
JOIN tblMember B WITH(NOLOCK)ON B.MemberID =A.MemberID
WHERE A.ContentID <= @PageColumn
ORDERBY A.ContentID DESC

SET ROWCOUNT 0

SET NOCOUNT OFF

GO