Question

那位大侠帮我写个 SqlServer分页存储过程 传进去的参数有pageIndex, pageSize, rowCount ,pageCount

Answer 1

存储过程本身不难写，关键是后台取数据时 必须要用滚动游标，将取到的数据放到一个
临时表里边。

追问

。。。那你帮我写个简单的不

追答

create procedure fetchrecord
@sqlstr nvarchar(4000), --查询字符串
@currentpage int, --第N页
@pagesize int --每页行数
as
set nocount on
declare @cur int, @rowcount int
exec sp_cursoropen @cur output,@sqlstr,@scrollopt=1,@ccopt=1,@rowcount=@rowcount output
select ceiling(1.0*@rowcount/@pagesize) as 总页数--,@rowcount as 总行数,@currentpage as 当前页
set @currentpage=(@currentpage-1)*@pagesize+1
exec sp_cursorfetch @cursor,16,@currentpage,@pagesize
exec sp_cursorclose @cursor
set nocount off