create proc up_gettopiclist
       @a_strforumid varchar(50) ,
       @a_intpageno int  ,
       @a_intpagesize int
as
   /*定义局部变量*/
   declare @intbeginid         int
   declare @intendid           int
   declare @introotrecordcount int
   declare @intpagecount       int
   declare @introwcount        int
   /*关闭计数*/
   set nocount on
   
  
   /*求总共根贴数*/
   select @introotrecordcount = count(*) from bbs_topic where fatherid=0 and forumid=@a_strforumid
   if (@introotrecordcount = 0)    –如果没有贴子，则返回零
       return 0
       
   /*判断页数是否正确*/
   if (@a_intpageno – 1) * @a_intpagesize > @introotrecordcount
      return (-1)

   /*求开始rootid*/
   set @introwcount = (@a_intpageno – 1) * @a_intpagesize + 1
   /*限制条数*/
   set rowcount @introwcount
   select @intbeginid = rootid from bbs_topic where fatherid=0 and forumid=@a_strforumid
          order by tid desc

   /*结束rootid*/
   set @introwcount = @a_intpageno * @a_intpagesize
   /*限制条数*/
   set rowcount @introwcount
   select @intendid = rootid from bbs_topic where fatherid=0 and forumid=@a_strforumid
          order by tid desc

   /*恢复系统变量*/
   set rowcount 0
   set nocount off   

   select a.tid , a.layer , a.forumid , a.subject , a.faceid , a.hits , a.posttime , a.userid , a.fatherid , a.rootid ,
         bytes = datalength(a.content) , b.loginname  , b.email  , b.homepage , b.signature , b.point
     from bbs_topic as a join bbs_user as b on a.userid = b.uid
     where forumid=@a_strforumid and a.rootid between @intendid and @intbeginid
         order by a.rootid desc , a.ordernum desc
   return(@@rowcount)
   –select @@rowcount
go    

怎么操作就不贴了！！大家好好看看，