반응형 게시판 쿼리1 페이지 쿼리 DECLARE @PageNumber AS INT , @RowsPage AS INT SET @PageNumber = 3 SET @RowsPage = 5 SELECT * FROM TABLE_NAME ORDER BY COLUMN_Name ASC OFFSET((@PageNumber - 1) * @RowsPage) ROWS FETCH NEXT @RowsPage ROWS ONLY 관련 URL http://social.technet.microsoft.com/wiki/contents/articles/23811.paging-a-query-with-sql-server.aspx 2015. 7. 27. 이전 1 다음 반응형