sql 分页查询

declare @page int  --第几页
declare @rownum int  --记录数

set @page=3
set @rownum=15

set rowcount @rownum
 SELECT *  
 FROM
         (
         SELECT ROW_NUMBER() OVER (ORDER BY id) AS RowNum,* FROM t_department
         ) A
 WHERE A.RowNum > @rownum*(@page-1)

 

--------------

--返回该表有几页

declare @rownum int  --@rownum 记录行
set @rownum=30
select  
 ( (count (*)/@rownum) +  case when (count (*))%@rownum >0 then 1 else 0 end  )
   from t_department