declare @nPageCount int, @nRecordCount int, @nPageSize int, @nGotoPage int;
set @nPageSize = 4; --自定义
set @nGotoPage = 1; --自定义
select
@nRecordCount = Count(*)
from
『tableNameANDwhere』;
set @nPageCount = Ceiling(@nRecordCount * 1.0 / @nPageSize);
select
_RecordCount = @nRecordCount, _PageCount = @nPageCount, *
from
(
select
Row_Number() over (order by 『OrderByField』 desc) as _RowID,
*
from
『tableNameANDwhere』
) as T
where
T._RowID > ((@nGotoPage - 1) * @nPageSize)
and T._RowID <= (@nGotoPage * @nPageSize);
分页查询语句(返回 该有的数据)
最新推荐文章于 2024-08-03 23:30:14 发布