22,207
社区成员
发帖
与我相关
我的任务
分享
create proc lin_proc
@page int
as
begin
select top 5 from (select top @page*5 from tb )tb1 order by datetime desc
end
declare @pagesize int
declare @page int
set @pagesize = --页大小
set @page = --页数
set @page = @page-1
SELECT TOP (@pagesize) *
FROM article
WHERE datatime <=( SELECT ISNULL(MAX(datatime),0) as datatime FROM (SELECT TOP (@pagesize * @page) datatime FROM article ORDER BY datatime desc) a)
ORDER BY datatime desc