alter PROCEDURE GetPageDataOutRowPageCount --创建则用 create替换alter ( @PageIndex int = 1,--当前页数 @PageSize int = 7,--每页大小 @RowCount int output,--总行数(传出参数) @PageCount int output--总页数(传出参数) ) AS begin --可以用begin end 包裹 DECLARE @sql NVARCHAR(225),@sqlCount NVARCHAR(225) select @RowCount =COUNT(SID),@PageCount=CEILING((COUNT(SID)+0.0)@PageSize) FROM Students where SIsDel=0 SET @sql='SELECT TOP '+str(@PageSize) +' FROM Students,Classes where SCID=CID and SIsDel=0 and SID not in(select top '+str((@PageIndex-1)@PageSize) +' SID from Students where SIsDel=0)' print @sql EXEC(@sql) end
--执行存储过程declare @rc int,@pc int
exec GetPageDataOutRowPageCount 1,3,@rc output,@pc output
select @rc,@pc
MSSQL分页存储过程
最新推荐文章于 2018-09-01 12:29:49 发布