菜鸟课堂：四种关于SQL查询信息分页的代码

goodluck

<p >过程一：select top N条记录 * from 文章表 where id not in(select top M条记录 id from 文章表 order by id desc ) order by id desc<p ><p >过程二：select top N条记录 * from 文章表 where id <(select min(id) from (select top M条记录 id from 文章表 order by id desc ) as tblTmp) order by id desc<p ><p >过程三：在数据库中写语句！<p ><p >create database mydb<p >go<p >use mydb<p >go<p >create table news<p >(id varchar(50) primary key,<p >name varchar(50)<p >)<p ><p >go<p >insert into news values('020','sss')<p >insert into news values('021','ttt')<p >insert into news values('022','uuu')<p >insert into news values('001','aaa')<p >insert into news values('002','bbb')<p >insert into news values('003','ccc')<p >insert into news values('004','aaa')<p >insert into news values('005','ddd')<p >insert into news values('006','eee')<p >insert into news values('007','fff')<p >insert into news values('008','ggg')<p >insert into news values('009','hhh')<p >insert into news values('010','iii')<p >insert into news values('011','jjj')<p >insert into news values('012','kkk')<p >insert into news values('013','lll')<p >insert into news values('014','mmm')<p >insert into news values('015','nnn')<p >insert into news values('016','ooo')<p >insert into news values('017','ppp')<p >insert into news values('018','qqq')<p >insert into news values('019','rrr')<p >go<p >select * from news<p >go<p ><p >create proc proc_cursor     --定义存储过程<p >@pagesize int,    --每页有多少条数据<p >@pageindex int,    --第几页<p >@pagetotal int output       --总页数<p >as<p >begin<p >declare @total int,@start int,@end int,@id varchar(10),@name varchar(10),@i int<p >--定义几个变量，作用后面解释<p ><p >declare mycur scroll cursor<p > for<p >select * from news order by ID--定义一个滚动游标<p ><p >open mycur--打开游标<p ><p >set @total = @@cursor_rows--得到总的记录数<p ><p >if @total> 0<p >begin<p >if @total % @pagesize = 0<p >     set @pagetotal = @total / @pagesize<p >else<p >     set @pagetotal = @total / @pagesize + 1<p >--得到总页数                                 <p align="center"><font color="FF0000" >1</font>2<span class="content01">下一页&gt;&gt;</span></p></p>