如何书写这句存储过程?aspnetpager中的.

2005-03-24 08:47:27 150 阅读 AI 写同款 · GEO 优化AI 选题数据监测一键分发 ›

iPhone存储空间耗尽自救指南：从“白苹果”死锁到成功保数据刷机本文详细介绍了iPhone存储空间耗尽导致'白苹果'死锁的解决方案，通过保留数据刷机方法成功恢复设备运行。文章分享了从失败尝试到最终成功的完整流程，包括关键操作步骤和预防措施，帮助用户在紧急情况下保住重要数据。阅读详情

ALTER procedure GsjyShowDGProcessor
(@where varchar(100),
@pagesize int,
@pageindex int,
@docount bit)
as
set nocount on
declare @RecordCount int
select @RecordCount=count (id) from news
if(@docount=1)
select @RecordCount
else
begin
if(@pageindex=1)
exec('select top '+@pagesize+'* from news'+@where+' order by indextime desc')
else
begin
declare @PageUpperBound int
declare @endrecords int
set @PageUpperBound=@pageindex*@pagesize
if(@PageUpperBound-@pagesize)>=@RecordCount
select ''
else if(@RecordCount-(@PageUpperBound-@pagesize)<=@pagesize)
begin
set @endrecords=@RecordCount-(@PageUpperBound-@pagesize)
exec('select * from (select top '+@endrecords+' * from news'+@where+' order by indextime)A order by indextime desc')
end
else
exec('select * from (select top '+@pagesize+'* from (select top '+@PageUpperBound+' * from news'+@where+' order by indextime desc)A order by indextime)B order by indextime desc')
end
end
set nocount off

我的@where参数是如"where a='1'and b='2' and c='3' ....."程序中生成的动态语句.
如何改写select @RecordCount=count (id) from news
使RecordCount 的值是条件中的记录总数,而不是所有的记录数.
这个@where参数该如何添上?
谢谢.

...全文