存儲過程的分頁!!
2024-07-21 02:22:36
供稿:網友
 
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 [email protected]_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 [email protected]_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 [email protected]_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 [email protected]_strforumid and a.rootid between @intendid and @intbeginid
         order by a.rootid desc , a.ordernum desc 
   return(@@rowcount)
   --select @@rowcount
go    
怎么操作就不貼了!!大家好好看看,,歡迎訪問網頁設計愛好者web開發。