Question

可以给我发个存储过程分页么？ 谢谢 552608128

Answer 1

select * from (select *,row_number() over(order by ID desc) as RowNumber from (select 字段 from 表) as c) as RowNumberTableSource where RowNumber between cast(((@pageindex - 1)* @pagesize+1) as varchar) and cast((@pagesize*@pageindex) as varchar)

简单实用的

Answer 2

declare @start int,@end int
@sql nvarchar(600)
set @sql=’select top’+str(@end-@start+1)+’+from T where rid not in(select top’+str(@str-1)+’Rid from T where Rid>-1)’
exec sp_executesql @sql

Answer 3

邮件已发，请查收