帮忙改一下存储过程
eyis 2005-10-09 02:26:48 把where子句变成参数传进去
CREATE procedure GetImageOrderByHot
(@pagesize int,
@pageindex int,
@docount bit)
as
set nocount on
if(@docount=1)
select count(Id) from ShineImage where validate = 1
else
begin
declare @indextable table(id int identity(1,1),nid int)
declare @PageLowerBound int
declare @PageUpperBound int
set @PageLowerBound=(@pageindex-1)*@pagesize
set @PageUpperBound=@PageLowerBound+@pagesize
set rowcount @PageUpperBound
insert into @indextable(nid) select Id from ShineImage where validate = 1 order by hits desc
select O.* from ShineImage O,@indextable t where O.Id=t.nid
and t.id>@PageLowerBound and t.id<=@PageUpperBound order by t.id
end
set nocount off
GO