我的日记本程序日记列表存储过程分页--drop proc procDiarycreate 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);

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