MSSQL Web에서 페이지 뽑기 SQL

declare @page_size int,

@page_num int

set @page_size = 10

set @page_num = 1

select row_num

, bno

, title

, content_text contentText

, view_count viewCount

, insert_date insertDate

, insert_user insertUser

, update_date updateDate

, update_user updateUser

from(

select row_number() over(order by bno desc) as row_num, *

from tbl_board

) T

where row_num > @page_size * (@page_num-1)

and row_num <= @page_size * @page_num

order by bno desc

 

 

-- 페이지 총 수

select CEILING(convert(float, count(*)) / @page_size) page_count

from tbl_board