四种关于SQL查询信息分页的代码

过程一：selecttopN条记录*from文章表whereidnotin(selecttopM条记录idfrom文章表orderbyiddesc)orderbyiddesc

过程二：selecttopN条记录*from文章表whereid<(selectmin(id)from(selecttopM条记录idfrom文章表orderbyiddesc)astblTmp)orderbyiddesc

过程三：在数据库中写语句！

createdatabasemydb

go

usemydb

go

createtablenews

(idvarchar(50)primarykey,

namevarchar(50)

)

go

insertintonewsvalues('020','sss')

insertintonewsvalues('021','ttt')

insertintonewsvalues('022','uuu')

insertintonewsvalues('001','aaa')

insertintonewsvalues('002','bbb')

insertintonewsvalues('003','ccc')

insertintonewsvalues('004','aaa')

insertintonewsvalues('005','ddd')

insertintonewsvalues('006','eee')

insertintonewsvalues('007','fff')

insertintonewsvalues('008','ggg')

insertintonewsvalues('009','hhh')

insertintonewsvalues('010','iii')

insertintonewsvalues('011','jjj')

insertintonewsvalues('012','kkk')

insertintonewsvalues('013','lll')

insertintonewsvalues('014','mmm')

insertintonewsvalues('015','nnn')

insertintonewsvalues('016','ooo')

insertintonewsvalues('017','ppp')

insertintonewsvalues('018','qqq')

insertintonewsvalues('019','rrr')

go

select*fromnews

go

createprocproc_cursor--定义存储过程

@pagesizeint,--每页有多少条数据

@pageindexint,--第几页

@pagetotalintoutput--总页数

as

begin

declare@totalint,@startint,@endint,@idvarchar(10),@namevarchar(10),@iint

--定义几个变量，作用后面解释

declaremycurscrollcursor

for

select*fromnewsorderbyID--定义一个滚动游标

openmycur--打开游标

set@total=@@cursor_rows--得到总的记录数

if@total>0

begin

if@total%@pagesize=0

set@pagetotal=@total/@pagesize

else

set@pagetotal=@total/@pagesize+1

--得到总页数