62,072
社区成员
发帖
与我相关
我的任务
分享
alter PROCEDURE [dbo].[GetsearchPage]
@nPage int,---第几页
@Pnum int,--每页页数
@key nvarchar(100),
@f_allidnum nvarchar(100) output --返回总页数
AS
declare @sql nvarchar(3000),@c nvarchar(20)
set @sql='WITH OrderedOrders AS
(SELECT count(id),soft_names,addtime,softsize,soft_garde,system_set,downcount,
ROW_NUMBER() OVER (order by [id])as RowNumber FROM soft where soft_names like ''%'+@key+'%'''+' )
SELECT id,soft_names,addtime,softsize,soft_garde ,system_set,downcount
FROM OrderedOrders
WHERE RowNumber>'+cast((@nPage-1)*@Pnum as nvarchar(50))+' and RowNumber<='+cast(@nPage*@Pnum as nvarchar(50))
set @sql=@sql+' order by addtime desc'
set @sql=@sql+' select '+cast(@f_allidnum as nvarchar(20))+'=count(*) from OrderedOrders '
exec(@sql)