急，关于数据表查询！

[hzcrazybb]

如何在没有关键索引可以定位的条件下实现数据表的连续查询：
先取出前20条记录，接着取下面的20条记录，、、、依次类推。

[txlicenhe]

参考：
http://expert.csdn.net/Expert/topic/2142/2142477.xml?temp=.7186701
分页处理
declare @SQLStr varchar(8000)
set @SQLStr='SELECT Top '+cast(@每页大小 as varchar)+' * FROM 表
WHERE num NOT IN (SELECT TOP '+cast(@每页大小*@第几页 as varchar)+' num from 表 )'
exec(@SQLStr)


查询N-M条记录。
select IDENTITY(int,1,1) as iid,* into #temptable from yourtable order by 排序字段
select top M-N * from #temptable where iid>=N

[friendliu]

select idenetity(int,1,1) as iid, * into #temp from tablename
select top * from #temp where id<=10
go
select top * from #temp where id>10 and id<=20
go

[伍子V5]

/*
用存储过程实现的分页程序
*/
CREATE procedure Department_pagination
@SelectStr nvarchar(1000),
@ColumnStr nvarchar (1000),
@OrderStr nvarchar (1000),
@CurrentPage int,
@PageCount int
as
declare @TimeName nvarchar(25)
declare @TableStr nvarchar(1000)

select @TimeName = convert(nvarchar(23), getdate(), 121)
set @TimeName = REPLACE(@TimeName, '.', '')
set @TimeName = REPLACE(@TimeName, ':', '')
set @TimeName = REPLACE(@TimeName, '-', '')
set @TimeName = REPLACE(@TimeName, ' ', '')

select @TableStr='create table ##Tab' + @TimeName + '(wb int identity,'
exec(@TableStr+@ColumnStr+')')
exec('insert into ##Tab' + @TimeName + ' ' + @SelectStr + ' order by ' + @OrderStr)
exec('select * from ##Tab' + @TimeName + ' where wb between ((' + @CurrentPage + '-1)*' + @PageCount + '+1) and ' + @CurrentPage + '*' + @PageCount + ' order by wb')
exec('drop table ##Tab' + @TimeName)
GO



参数1：select语句。2：字段列表。3：排序字段。4：当前页。5每页数目

[zjcxc]

刚开了一个贴子,针对此问题:

http://expert.csdn.net/Expert/topic/2365/2365596.xml?temp=5.801028E-02

[zjcxc]

最基本的处理方法:

如果表中无主键,可以用临时表,加标识字段解决.这里的x,y可以用变量.

select id=identity(int,1,1),* into #tb from 表
select * from #tb where id between (x-1)*y and x*y-1