日本国产亚洲-日本国产一区-日本国产一区二区三区-日本韩国欧美一区-日本韩国欧美在线-日本韩国欧美在线观看

當前位置:雨林木風下載站 > 技術開發教程 > 詳細頁面

存儲過程分頁

存儲過程分頁

更新時間:2022-05-08 文章作者:未知 信息來源:網絡 閱讀次數:

if exists(select * from sysobjects where ID = object_id("up_TopicList"))
   drop proc up_TopicList
go

create proc up_TopicList
            @a_ForumID int , @a_intDays int , @a_intPageNo int , @a_intPageSize tinyint
   as
       declare @m_intRecordNumber int
       declare @m_intStartRecord  int
       select @m_intRecordNumber = @a_intPageSize * @a_intPageNo
       select @m_intStartRecord = @a_intPageSize * (@a_intPageNo - 1) + 1

       if @a_intDays = 0                      --如果不限定天數
          begin
                /*求符合條件記錄數*/
                select "RecordCount" = count(*)                         
                       from BBS where Layer=1 and ForumID = @a_ForumID

               /*輸出紀錄*/
               /*首先定義可滾動光標*/
               set rowcount @m_intRecordNumber
               declare m_curTemp Scroll cursor
                       for
                          select a.ID ,a.Title , d.UserName , a.FaceID ,
                                'ContentSize' = datalength(a.Content) ,
                                'TotalChilds' = (select sum(TotalChilds)
                                                        from BBS as b
                                                        where a.RootID = b.RootID) ,
                                'LastReplyTime' = (select max(PostTime)
                                                          from BBS as c
                                                          where a.RootID = c.RootID)
                                from BBS as a
                                     join BBSUser as d on a.UserID = d.ID
                                where Layer=1 and ForumID = @a_ForumID
                                order by RootID desc , Layer , PostTime
               open m_curTemp
               fetch absolute @m_intStartRecord from m_curTemp
               while  @@fetch_status = 0
                      fetch next from m_curTemp

               set rowcount 0
               /*清場*/       
               CLOSE m_curTemp
               DEALLOCATE m_curTemp
          end                      
                          
       else                                --如果限定天數          

          begin
                /*求符合條件記錄數*/
                select "RecordCount" = count(*)                         
                       from BBS where Layer=1 and ForumID = @a_ForumID
                                      and dateadd(day , @a_intDays , PostTime) > getdate()

               /*輸出紀錄*/
               /*首先定義可滾動光標*/
               set rowcount @m_intRecordNumber
               declare m_curTemp Scroll cursor
                       for
                          select a.ID ,a.Title , d.UserName , a.FaceID ,
                                'ContentSize' = datalength(a.Content) ,
                                'TotalChilds' = (select sum(TotalChilds)
                                                        from BBS as b
                                                        where a.RootID = b.RootID) ,
                                'LastReplyTime' = (select max(PostTime)
                                                          from BBS as c
                                                          where a.RootID = c.RootID)
                                from BBS as a
                                     join BBSUser as d on a.UserID = d.ID
                                where Layer=1 and ForumID = @a_ForumID
                                      and dateadd(day , @a_intDays , PostTime) > getdate()
                                order by RootID desc , Layer , PostTime
               open m_curTemp
               fetch absolute @m_intStartRecord from m_curTemp
               while  @@fetch_status = 0
                      fetch next from m_curTemp

               set rowcount 0
               /*清場*/       
               CLOSE m_curTemp
               DEALLOCATE m_curTemp
          end                                                
go


注:若在asp中調用存儲過程的command對象為cm,則set rs=cm.execute,然后用set rs=rs.nextrecordset取下一條記錄。

溫馨提示:喜歡本站的話,請收藏一下本站!

本類教程下載

系統下載排行

主站蜘蛛池模板: 国产啪爱视频精品免视 | 国产精品大尺度尺度视频 | 亚洲国产成人精品区 | 欧美日韩在线视频一区 | 亚洲高清视频在线观看 | 夜夜操夜夜操 | 免费永久国产在线视频 | 日韩精品中文字幕在线观看 | 色婷婷天天综合在线 | 曰曰摸天天摸人人看久久久 | 国产亚洲精品美女久久久久久2021 | 37pao成人国产永久免费视频 | 日韩一区二区免费看 | 国产在视频 | 国产美女主播一级成人毛片 | 久久精品一区二区国产 | 天天5g天天看 | 久久综久久美利坚合众国 | 毛片视频网站在线观看 | 91中文字幕在线观看 | 久久国产精品网 | 成年人午夜视频 | 日本不卡视频免费 | 91天堂在线 | 国产成人1024精品免费 | 中日韩美中文字幕 | 婷婷在线免费观看 | 亚洲a人片在线观看网址 | 天天综合影视 | 淫综合网| 日日狠狠久久8888av | 午夜免费片在线观看不卡 | 日韩久久视频 | 青青草在线看 | 欧美日本在线三级视频 | 日韩精品一区二区三区国语自制 | 2021久久伊人精品中文字幕有 | 国产精品久久久久久 | 欧美亚洲国产成人综合在线 | 四虎影院成人在线观看 | 草草久久97超级碰碰碰免费 |