我的日记本程序日记列表存储过程分页(2)改进正式可用

我的日记本程序日记列表存储过程分页

--drop proc procDiary
create proc procDiary	--获取日记列表的分页存储过程
	@pageSize int =12,	--
	@pageIndex int=1,	--页码序号
	@totalCount int output,	--总记录数
	@diaryWhere varchar(255)
	
as
	declare @strSql varchar(500);
	set @totalCount =CONVERT(int,(select COUNT(1) from t_Diary));
	set @strSql = 'set nocount on select top ('+convert(varchar(50),@pageSize)+') fid,fcid,ftopical,faddDate,feditDate 
	into #diary from t_Diary
	where Fid not in(select top (('+convert(varchar	(50),@pageIndex)+'-1)*'+convert(varchar(50),@pageSize)+') fid from t_Diary order by FaddDate desc,Fid desc)'
	+ convert(varchar(255),@diaryWhere) +
	'order by FaddDate desc,Fid desc
	select * from #diary
	drop table #diary set nocount off';
	exec(@strSql);

转载于:https://www.cnblogs.com/liuguangyin/p/3967207.html