declare @pagelowerbound int --定义此页的底码
declare @pageupperbound int --定义此页的顶码
set @pagelowerbound=(@pageindex-1)*@pagesize
set @pageupperbound=@pagelowerbound+@pagesize
set rowcount @pageupperbound
insert into @indextable(nid) select gid from tgongwen where fariqi >dateadd(day,-365,getdate()) order by fariqi desc
select o.gid,o.mid,o.title,o.fadanwei,o.fariqi from tgongwen o,@indextable t where o.gid=t.nid
and t.id>@pagelowerbound and t.id<=@pageupperbound order by t.id
end
set nocount off
