²»ÄÜÔòѧ£¬²»ÖªÔòÎÊ£¬³ÜÓÚÎÊÈË£¬¾öÎÞ³¤½ø.

Çë×ðÖØ°æȨ

´æ´¢¹ý³Ì·ÖÒ³

[pre]CREATE PROCEDURE GetRecordFromPage   @tblName   varchar(255),   -- ±íÃû   @fldName   varchar(255),   -- ×Ö¶ÎÃû   @PageSize   int = 10,     -- Ò³³ß´ç   @PageIndex   int = 1,       -- Ò³Âë   @IsCount   bit = 0,       -- ·µ»Ø¼Ç¼×ÜÊý, ·Ç 0 ÖµÔò·µ»Ø   @OrderType   bit = 0,       -- ÉèÖÃÅÅÐòÀàÐÍ, ·Ç 0 ÖµÔò½µÐò   @strWhere   varchar(1000) = '' -- ²éѯÌõ¼þ (×¢Òâ: ²»Òª¼Ó where)ASdeclare @strSQL   varchar(1000)   -- Ö÷Óï¾ädeclare @strTmp   varchar(300)   -- ÁÙʱ±äÁ¿declare @strOrder varchar(400)   -- ÅÅÐòÀàÐÍif @OrderType != 0begin   set @strTmp = "<(select min"   set @strOrder = " order by [" + @fldName +"] desc"endelsebegin   set @strTmp = ">(select max"   set @strOrder = " order by [" + @fldName +"] asc"endset @strSQL = "select top " + str(@PageSize) + " * from ["   + @tblName + "] where [" + @fldName + "]" + @strTmp + "(["   + @fldName + "]) from (select top " + str((@PageIndex-1)*@PageSize) + " ["   + @fldName + "] from [" + @tblName + "]" + @strOrder + ") as tblTmp)"   + @strOrderif @strWhere != ''   set @strSQL = "select top " + str(@PageSize) + " * from ["   + @tblName + "] where [" + @fldName + "]" + @strTmp + "(["   + @fldName + "]) from (select top " + str((@PageIndex-1)*@PageSize) + " ["   + @fldName + "] from [" + @tblName + "] where (" + @strWhere + ") "   + @strOrder + ") as tblTmp) and (" + @strWhere + ") " + @strOrderif @PageIndex = 1begin   set @strTmp = ""   if @strWhere != ''   set @strTmp = " where (" + @strWhere + ")"   set @strSQL = "select top " + str(@PageSize) + " * from ["   + @tblName + "]" + @strTmp + " " + @strOrderendif @IsCount != 0   set @strSQL = "select count(*) as Total from [" + @tblName + "]"exec (@strSQL)GO[/pre] [url=file:///C:/Documents%20and%20Settings/Administrator/¥Ç¥¹¥¯¥È¥Ã¥×/csdn_3447156.htm#top]Top »Ø¸´ÈË£º jianli0108(¼¤¹â) ( ) ÐÅÓþ£º98 2004-10-12 11:32:43 µÃ·Ö:0 [pre]/*·ÖÒ³´æ´¢¹ý³ÌDescript:·ÖÒ³´æ´¢¹ý³ÌAuthor:Blue.DreamDate:2004-8-18 21:01*/Create PROCEDURE ListPage(@tblName     nvarchar(200),             ----ÒªÏÔʾµÄ±í»ò¶à¸ö±íµÄÁ¬½Ó@fldName     nvarchar(200) = '*',         ----ÒªÏÔʾµÄ×Ö¶ÎÁбí@pageSize     int = 10,                 ----ÿҳÏÔʾµÄ¼Ç¼¸öÊý@page         int = 1,             ----ÒªÏÔʾÄÇÒ»Ò³µÄ¼Ç¼@pageCount     int = 1 output,         ----²éѯ½á¹û·ÖÒ³ºóµÄ×ÜÒ³Êý@Counts     int = 1 output,             ----²éѯµ½µÄ¼Ç¼Êý@fldSort     nvarchar(100) = null,         ----ÅÅÐò×Ö¶ÎÁбí»òÌõ¼þ@Sort         bit = 0,             ----ÅÅÐò·½·¨£¬0ΪÉýÐò£¬1Ϊ½µÐò@strCondition     nvarchar(200) = null,     ----²éѯÌõ¼þ,²»Ðèwhere@ID         nvarchar(50)         ----Ö÷±íµÄÖ÷¼ü)ASSET NOCOUNT ONDeclare @sqlTmp nvarchar(1000)         ----´æ·Å¶¯Ì¬Éú³ÉµÄSQLÓï¾äDeclare @strTmp nvarchar(1000)         ----´æ·ÅÈ¡µÃ²éѯ½á¹û×ÜÊýµÄ²éѯÓï¾äDeclare @strID     nvarchar(1000)         ----´æ·ÅÈ¡µÃ²éѯ¿ªÍ·»ò½áβIDµÄ²éѯÓï¾äDeclare @sqlSort nvarchar(200)         ----´æ·ÅÁÙʱÉú³ÉµÄÅÅÐòÌõ¼þDeclare @intCounts int             ----ÒªÒƶ¯µÄ¼Ç¼ÊýDeclare @BeginID int             ----¿ªÊ¼µÄIDDeclare @EndID   int             ----½áÊøµÄID--------Ê×ÏÈÉú³ÉÅÅÐò·½·¨---------if @Sort=0         --ÉýÐòbegin     if not(@fldSort is null)         set @sqlSort = ' Order by ' + @fldSort         else         set @sqlSort = ' Order by ' + @ID endelse             --½µÐòbegin     if not(@fldSort is null)         set @sqlSort = ' Order by ' + @fldSort + ' DESC'             else         set @sqlSort = ' Order by ' + @ID + ' DESC 'end--------Éú³É²éѯÓï¾ä----------´Ë´¦@strTmpΪȡµÃ²éѯ½á¹ûÊýÁ¿µÄÓï¾äif @strCondition is null     --ûÓÐÉèÖÃÏÔʾÌõ¼þ     begin     set @sqlTmp = @fldName + ' From ' + @tblName     set @strTmp = 'select @Counts=Count(' + @ID + ') FROM '+@tblName     set @strID = ' From ' + @tblName     endelse     begin     set @sqlTmp = + @fldName + 'From ' + @tblName + ' where ' + @strCondition     set @strTmp = 'select @Counts=Count(' + @ID + ') FROM '+@tblName + ' where ' + @strCondition     set @strID = ' From ' + @tblName + ' where ' + @strCondition     end     ----È¡µÃ²éѯ½á¹û×ÜÊýÁ¿-----exec sp_executesql @strTmp,N'@Counts int out ',@Counts out--È¡µÃ·ÖÒ³×ÜÊýif @Counts <= @pageSize     set @pageCount = 1else     set @pageCount = (@Counts / @pageSize) + 1--¼ÆËãÒªÒƶ¯µÄ¼Ç¼Êýif @page = 1     set @intCounts = @pageSizeelsebegin     set @intCounts = (@page-1) * @pageSize + 1end-----È¡µÃ·ÖÒ³ºó´ËÒ³µÄµÚÒ»Ìõ¼Ç¼µÄIDset @strID = 'select @BeginID=' + @ID + ' ' + @strIDset @intCounts = @intCounts - @pageSize + 1set rowcount @intCountsexec sp_executesql @strID,N'@BeginID int out ',@BeginID out-----È¡µÃ·ÖÒ³ºó´ËÒ³µÄ×îºóÒ»Ìõ¼Ç¼µÄIDset @intCounts = @intCounts + @pageSize - 1print @intCountsset rowcount @intCountsexec sp_executesql @strID,N'@BeginID int out ',@EndID out------»Ö¸´ÏµÍ³ÉèÖÃ-----set rowcount 0SET NOCOUNT OFF------·µ»Ø²éѯ½á¹û-----if @strCondition is null     set @strTmp = 'select ' + @sqlTmp + ' where ' + @ID + ' between ' + str(@BeginID) + ' and ' + str(@EndID)else     set @strTmp = 'select ' + @sqlTmp + ' where ' + @ID +' (between ' + str(@BeginID) + ' and ' + str(@EndID) + ') and ' + @strConditionif not(@sqlSort is null)set @strTmp = @strTmp + @sqlSortexec sp_executesql @strTmpGO[/pre] [url=file:///C:/Documents%20and%20Settings/Administrator/¥Ç¥¹¥¯¥È¥Ã¥×/csdn_3447156.htm#top]Top »Ø¸´ÈË£º weihua99(ÎÒ°®DotNet) ( ) ÐÅÓþ£º80 2004-10-12 11:43:14 µÃ·Ö:0 [pre]×îºÃ´øÓе÷Óô洢¹ý³ÌµÄÀý×Ó¡£[/pre] [url=file:///C:/Documents%20and%20Settings/Administrator/¥Ç¥¹¥¯¥È¥Ã¥×/csdn_3447156.htm#top]Top »Ø¸´ÈË£º serverme(Ì«À§ÁË£¬Ïë˯¾õ) ( ) ÐÅÓþ£º100 2004-10-12 16:04:00 µÃ·Ö:0 [pre]ÕâÊÇÎÒÓÃASPдµÄÄã¸Ä³É.NETµÄ¾ÍºÃÁË-------------------------------------·ÖÒ³µÄ´æ´¢¹ý³Ì-------------------------- ÀûÓÃSQLδ¹«¿ªµÄ´æ´¢¹ý³ÌʵÏÖ·ÖÒ³CREATE procedure p_splitpage   @sql nvarchar(4000),     --ÒªÖ´ÐеÄsqlÓï¾ä@page int=1,             --ÒªÏÔʾµÄÒ³Âë@pageSize int,         --ÿҳµÄ´óС@pageCount int=0 out,     --×ÜÒ³Êý@recordCount int=0 out     --×ܼǼÊýasset nocount ondeclare @p1 intexec sp_cursoropen @p1 output,@sql,@scrollopt=1,@ccopt=1,@rowcount=@pagecount outputset @recordCount = @pageCountselect @pagecount=ceiling(1.0*@pagecount/@pagesize)     ,@page=(@page-1)*@pagesize+1exec sp_cursorfetch @p1,16,@page,@pagesize exec sp_cursorclose @p1GO---------------------------µÃµ½Ö´ÐеIJéѯÓï¾äµÄ´æ´¢¹ý³Ì-----------------CREATE PROCEDURE dtalyjd_search (@search_name varchar(50)) ASDECLARE @str varchar(4000)     if @search_name=''         begin             set @str='select * from ±íÃû'             select @str sql             return         end     else         begin             set @str='select * from ±íÃû where search_name like ''%'+@search_name+'%'''             select @str sql             return         endGO--------------------------ASPÒ³Ãæ---------------------<%     dim search_name     search_name=trim(request("search_name"))     set rs1=conn.execute("exec dtalyjd_search '"&search_name&"'")     sql=rs1("sql")     rs1.close     if request("page")="" or request("page")=0 or IsNumeric(request("page"))=false then         m_page=1             else         m_page=cint(request("page"))     end if     m_pagesize=14'ÿҳµÄÌõÊý     set cmd = server.CreateObject("adodb.command")   cmd.ActiveConnection = conn   cmd.CommandType = 4   cmd.CommandText = "p_SplitPage"   cmd.Parameters.Append cmd.CreateParameter("@sql",8,1, 4000, sql)   cmd.Parameters.Append cmd.CreateParameter("@page",4,1, 4, m_page)   cmd.Parameters.Append cmd.CreateParameter("@pageSize",4,1, 4, m_pageSize)   cmd.Parameters.Append cmd.CreateParameter("@pageCount",4,2, 4, m_pageCount)   cmd.Parameters.Append cmd.CreateParameter("@recordCount",4,2, 4, m_recordCount)   set rs = cmd.Execute     set rs = rs.NextRecordSet     m_pageCount = cmd.Parameters("@pageCount").value   m_recordCount = cmd.Parameters("@recordCount").value     if m_pageCount = 0 then m_pageCount = 1     if m_page>m_pageCount then         response.Redirect("bureauser_result.asp?page="&m_pageCount&"&lxsuser_name="&lxsuser_name)     end if     set rs = cmd.Execute%> <table width="100%" border="0" cellspacing="1" cellpadding="0">             <tr>               <td width="47%" align="right">²éѯ½á¹û¹² <font color="#FF0000">[8]</font>               Ò³ ÕâÊÇµÚ <font color="#FF0000">[5]</font> Ò³ </td>               <td width="53%" align="right"><table width="95%" border="0" cellspacing="0" cellpadding="0">               <tr>                 <td width="10" align="right" ><img src="feedback_images/ll.gif" width="8" height="21"></td>                 <td width="475" background="feedback_images/m.gif"><table width="100%" border="0" cellspacing="0" cellpadding="0">                   <tr>                                             <%                                                 if m_page<>1 then                                             %>                   <td width="23%"><img src="/images/first.gif" width="8" height="8"> <A href="/<";%=Myself%>?Page=1&search_name=<%=search_name%>>Ê×Ò³</A></td>       <td width="31%"><img src="/images/pre.gif" width="8" height="8"> <A href="/<";%=Myself%>?Page=<%=(Page-1)%>&search_name=<%=search_name%>>ÉÏÒ»Ò³</a></td>                                         <%                                             end if                                             If m_page <> m_pageCount Then                                         %>                   <td width="24%"><img src="/images/lat.gif" width="8" height="8"><A href="/<";%=Myself%>?Page=<%=(m_Page+1)%>&search_name=<%=search_name%>>ÏÂÒ»Ò³</A></td>       <td width="22%"><img src="/images/last.gif" width="8" height="8"><A href="/<";%=Myself%>?Page=<%=m_pageCount%>&search_name=<%=search_name%>>βҳ</A></td>                                         <%end if%>                   </tr><%end if%>                 </table></td>                 <td width="11"><img src="feedback_images/rr.gif" width="10" height="21"></td>               </tr>               </table>               </td>             </tr>           </table>[/pre][pre]sql ´æ´¢¹ý³Ì·ÖÒ³ £¨Õª×Ôhttp://www.itlearner.com/article/£© [/pre][pre]CREATE PROC myx_prPageRecordset @queryStr nvarchar(1000), @keyField nvarchar (200), @pageSize int, @pageNumber int AS BEGIN DECLARE @sqlText AS nvarchar(4000) DECLARE @sqlTable AS nvarchar(4000) SET @sqlTable = 'SELECT TOP ' + CAST((@pageNumber + 1) * @pageSize AS varchar(30)) + ' ' + @queryStr SET @sqlText = 'SELECT TOP ' + CAST(@pageSize AS varchar(30)) + ' * ' + 'FROM (' + @sqlTable + ') AS tableA ' + 'WHERE ' + @keyField + ' NOT IN(SELECT TOP ' + CAST(@pageNumber * @pageSize AS varchar(30)) + ' ' + @keyField + ' FROM (' + @sqlTable + ') AS tableB)' EXEC (@sqlText) END[/pre][pre]GO[/pre][pre]ºËÐÄ´úÂë Dim strsql As String myComm = New SqlClient.SqlCommand("myx_prPageRecordset", myConn) myComm.CommandType = CommandType.StoredProcedure myComm.Parameters.Add(New SqlClient.SqlParameter("@queryStr", SqlDbType.NVarChar, 1000)) myComm.Parameters("@queryStr").Value = " * from tbpage order by id DESC" myComm.Parameters.Add(New SqlClient.SqlParameter("@keyField", SqlDbType.NVarChar, 200)) myComm.Parameters("@keyField").Value = "[id]" myComm.Parameters.Add(New SqlClient.SqlParameter("@pageSize", SqlDbType.NVarChar, 1000)) myComm.Parameters("@pageSize").Value = PageSize myComm.Parameters.Add(New SqlClient.SqlParameter("@pageNumber", SqlDbType.NVarChar, 1000)) myComm.Parameters("@pageNumber").Value = myPage - 1[/pre][pre]ºÇºÇ,Ö´Ðм¸WÌõµÄ´úÂëÖ»Ðè150ºÁÃë×óÓÒ[/pre][pre]½¨Á¢Ò»¸ötest(id,name,fid) ÏòtestÌí³ä¼¸Ê®ÌõÊý¾Ý,ʹid=1,2,3,4.........(¼´µÝÔöµÄinteger),ÆäËûÈÎÒâ ÔÚT-sql Debugger¸ø¸Ä´æ´¢¹ý³Ì·Ö±ð´«µÝÈçϲÎÊý: @queryStr= * from test @keyField=[ID] @pageSize=3 @pageNumber=1 ÎÊÌâ³öÀ´ÁË,¿´Êä³ö½á¹û(×¢Òâid): id name fid 4 kwklover 2 5 kwklover 2 6 kwklover 2 ¸ù¾Ý´«Èë²ÎÊý,ÎÒÃǵÄÔ¤ÆÚÓ¦¸ÃÊÇ: id name fid 1 kwklover 2 2 kwklover 2 3 kwklover 2[/pre][pre]ÏÂÃæÊÇÎÒ²ÎÕÕС´ºµÄ´æ´¢·ÖҳдµÄ·ÖÒ³´æ´¢¹ý³Ì,¿ÉÒÔ½â¾öÉÏÃæµÄÎÊÌâ: CREATE Procedure prGetRecordByPage ( @PageSize int, --ÿҳµÄ¼Ç¼ÌõÊý @PageNumber int, --µ±Ç°Ò³Ãæ @QuerySql varchar(1000),--²¿·Ö²éѯ×Ö·û´®,Èç* From Test order by id desc @KeyField varchar(500) ) AS Begin[/pre][pre]Declare @SqlTable AS varchar(1000) Declare @SqlText AS Varchar(1000)[/pre][pre]Set @SqlTable='Select Top '+CAST(@PageNumber*@PageSize AS varchar(30))+' '+@QuerySql Set @SqlText='Select Top '+Cast(@PageSize AS varchar(30))+' * From ' +'('+@SqlTable+') As TembTbA ' +'Where '+@KeyField+' Not In (Select Top '+CAST((@PageNumber-1)*@PageSize AS varchar(30))+' '+@KeyField+' From ' +'('+@SqlTable+') AS TempTbB)' Exec(@SqlText)[/pre][pre]End GO[/pre][pre]if exists(select * from sysobjects where id = object_id('up_GetTopicList')) ¬£ drop proc up_GetTopicList go create proc up_GetTopicList ¬£¬£¬£ @a_intForumID int , ¬£¬£¬£ @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 ¬£ ¬£ /*¼ì²âÊÇ·ñÓÐÕâ¸ö°æÃæ*/ ¬£ if not exists(select * from forum where id = @a_intForumID) ¬£¬£¬£return (-1) ¬£ ¬£ /*Çó×ܹ²¸ùÌùÊý*/ ¬£ select @intRootRecordCount = count(*) from bbs where fatherid=0 and forumid=@a_intForumID ¬£ 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 where fatherid=0 and forumid=@a_intForumID ¬£¬£¬£¬£¬£order by id desc ¬£ /*½áÊørootID*/ ¬£ set @intRowCount = @a_intPageNo * @a_intPageSize ¬£ /*ÏÞÖÆÌõÊý*/ ¬£ set rowcount @intRowCount ¬£ select @intEndID = rootid from bbs where fatherid=0 and forumid=@a_intForumID ¬£¬£¬£¬£¬£order by id desc ¬£ /*»Ö¸´ÏµÍ³±äÁ¿*/ ¬£ set rowcount 0 ¬£ set nocount off¬£ ¬£ select a.id , a.layer , a.forumid , a.subject , a.faceid , a.hits , a.time , a.UserID , a.fatherid , a.rootid , ¬£¬£¬£¬£ 'Bytes' = datalength(a.content) , b.UserName , b.Email , b.HomePage , b.Signature , b.Point ¬£¬£ from bbs as a join BBSUser as b on a.UserID = b.ID ¬£¬£ where Forumid=@a_intForumID and a.rootid between @intEndID and @intBeginID ¬£¬£¬£¬£ order by a.rootid desc , a.ordernum desc ¬£ return(@@rowcount) ¬£ --select @@rowcount go¬£¬£ Òª´´½¨Ò»¸ö·µ»ØÖ¸¶¨Ìõ¼Ç¼½á¹ûµÄ´æ´¢¹ý³Ì£¬Ê×ÏȱØÐëÖ¸¶¨·µ»Ø½á¹û¼¯µÄÌõ¼Ç¼Êý£¬¿ÉÒÔÓÃÁÙʱ±í£¬Ò²¿ÉÒÔÓÃtable±äÁ¿£¨SQL Server 2000£©£¬Á½¸öÔÚÐÔÄÜÉÏûÓÐÌ«´óµÄ²î±ð£¬µ«ÊÇ£¬table±äÁ¿ÊÇ´æ´¢ÔÚÄÚ´æÖеģ¬Èç¹ûÄãµÄ·þÎñÆ÷ÄÚ´æ²»¶àµÄ»°£¬¿ÉÒÔ¿¼ÂÇÓÃÁÙʱ±í£¬ÁÙʱ±íʹÓÃÓ²ÅÌ´æ´¢½á¹û£¬ÁÙʱ±íÐèÒªÊÖ¹¤ÊͷŶÔÏ󣬶øtable±äÁ¿ÔÚ´æ´¢¹ý³Ì½áÊøºó×Ô¶¯ÊÍ·Å¡£ ****** Object: Stored Procedure dbo.SelectTitle   Script Date: 2005-4-14 21:49:41 ******/ CREATE       Procedure EducateInfo_SelectTitle[/pre][pre]   ÏÂÃæ¾ÍÊÇÎÒÃÇÒª´´½¨µÄ´æ´¢¹ý³Ì£º[/pre][pre] create proc GetAuthors @Author_Last_Name as varchar(100) = null, @StartRow as int = null, @StopRow as int = null AS ---- ½¨Á¢Óбêʶ·ûÁеÄtable±äÁ¿ declare @t_table table ( [rownum] [int] IDENTITY (1, 1) Primary key NOT NULL , [Author_Last_Name] [varchar] (40) , [Author_First_Name] [varchar] (20) , [phone] [char] (12) , [address] [varchar] (40) , [city] [varchar] (20) , [state] [char] (2) , [zip] [char] (5) ) ---- ÔÚ·µ»ØÖ¸¶¨µÄ@StopRowÐÐÊýÖ®ºóÍ£Ö¹´¦Àí²éѯ Set RowCount @StopRow ---- ²åÈëµ½table±äÁ¿ÖÐ insert @t_table ( [Author_Last_Name],[Author_First_Name],[phone],[address],[city],[state],[zip] ) SELECT [Author_Last_Name],[Author_First_Name],[phone],[address],[city],[state],[zip] FROM authors WHERE Author_Last_Name like '%' + @Author_Last_Name + '%' ORDER BY Author_Last_Name ---- ·µ»Øµ½ÕýÈ·µÄ½á¹û SELECT * FROM @t_table WHERE rownum >= @StartRow ORDER BY rownum GO [/pre][pre][/pre][pre]/* ¹¦ÄÜ£ºÈ¡³ö½ÌÓýÐÅÏ¢¼Ç¼±êÌâ µ÷ÓãºÎÞ ×÷ÕߣºÖì¸ùÇ¿ Íê³ÉÈÕÆÚ£º05/04/15[/pre][pre] ÐÞ¸ÄÕߣº ÐÞ¸ÄÈÕÆÚ£º ÐÞ¸Ä˵Ã÷£º ²âÊÔ£º EducateInfo_SelectTitle 24,107,0,4,0,0 */[/pre][pre]( @intCategoryID   INT =0,   --±íID,1-PolicyandLaw,2-NewsOfEducation,3-FaxOfSchool,4-CollegueOfHeNan,5-OrgnizationOfEdu @intType   INT,   -- Àà±ðID @bitIsMore   BIT,     --ÊÇ·ñ·ÖÒ³ @intRecordOfPage INT,   --ÿҳµÄ¼Ç¼Êý @intPageNo   INT,   --µ±Ç°µÄÒ³Âë @intRecordNumber   INT OUTPUT   --¼Ç¼×ÜÊý ) AS DECLARE @ROWSET   INT --È¡³öµÄÐÐÊý DECLARE @intTop   INT --ÉèÖÃÊÜÓ°ÏìµÄÐÐÊý select @intRecordNumber = 0[/pre][pre]/*н¨Ò»¸ö»º´æ±í£¬ÓÃÀ´´æ´¢ÁÙʱÊý¾Ý */ DECLARE @cacheTopicListTable TABLE ( [ID]   INT, Type   INT, LawName   NVARCHAR(50), PostDate DATETIME, Author   NVARCHAR(30), Range   INT, Homepage NVARCHAR(100) ) /*´ÓPolicyandLaw±íÖÐÈ¡Êý¾Ý */ IF(@intCategoryID=24) BEGIN IF(@bitIsMore=0) --²»·­Ò³Ê± BEGIN IF(@intRecordOfPage=0) SELECT TOP 10 ID,Type,LawName, PostDate,Author FROM PolicyandLaw ORDER   BY PostDate DESC ELSE   BEGIN SET ROWCOUNT @intRecordOfPage SELECT ID,Type,LawName, PostDate,Author FROM PolicyandLaw WHERE [url=mailto:Type=@intType]Type=@intType ORDER   BY PostDate DESC END END ELSE --·­Ò³Ê± BEGIN SET @intRecordNumber=(SELECT COUNT(*)     FROM PolicyandLaw     WHERE [url=mailto:Type=@intType]Type=@intType ) --ÐÞÕýÊä³öµÄÆðʼÐкŠIF (@intRecordOfPage * @intPageNo> @intRecordNumber) SET @intTop = @intRecordNumber % @intRecordOfPage ELSE SET @intTop = @intRecordNumber-(@intRecordOfPage * (@intPageNo-1)) --²åÈëÊý¾Ý»º´æ±í SET ROWCOUNT @intTop INSERT INTO @cacheTopicListTable(   [ID],         Type,         LawName,       PostDate,       Author         )   SELECT   [ID],   Type,   LawName,   PostDate,   Author FROM PolicyandLaw WHERE [url=mailto:Type=@intType]Type=@intType SET ROWCOUNT @intRecordOfPage SELECT [ID],Type,LawName,PostDate,Author FROM @cacheTopicListTable ORDER BY [ID] Desc END END ELSE IF(@intCategoryID=25) /*´ÓNewsOfEducation±íÖÐÈ¡Êý¾Ý */ BEGIN IF(@bitIsMore=0) --²»·­Ò³Ê± BEGIN IF(@intRecordOfPage=0) SELECT TOP 18 ID,Type,NewsName, PostDate,Author FROM NewsOfEducation ORDER   BY PostDate DESC ELSE BEGIN SET ROWCOUNT @intRecordOfPage SELECT   ID,Type,NewsName,PostDate,Author,Range   FROM NewsOfEducation WHERE [url=mailto:Type=@intType]Type=@intType END END ELSE --·­Ò³Ê± BEGIN SET @intRecordNumber=(SELECT COUNT(*)     FROM NewsOfEducation     WHERE [url=mailto:Type=@intType]Type=@intType ) --ÐÞÕýÊä³öµÄÆðʼÐкŠIF (@intRecordOfPage * @intPageNo> @intRecordNumber) SET @intTop = @intRecordNumber % @intRecordOfPage ELSE SET @intTop = @intRecordNumber-(@intRecordOfPage * (@intPageNo-1)) --²åÈëÊý¾Ý»º´æ±í SET ROWCOUNT @intTop INSERT INTO @cacheTopicListTable( [ID],         Type,         LawName,       PostDate,       Author,       Range     )   SELECT   [ID],   Type,   NewsName,   PostDate,   Author,   Range FROM NewsOfEducation WHERE [url=mailto:Type=@intType]Type=@intType SET ROWCOUNT @intRecordOfPage SELECT   [ID],   Type,   LawName AS NewsName,   PostDate,   Author,   Range FROM @cacheTopicListTable ORDER BY [ID] Desc END END ELSE IF(@intCategoryID=26) /*´ÓFaxOfSchool±íÖÐÈ¡Êý¾Ý */ BEGIN IF(@bitIsMore=0) --²»·­Ò³Ê± BEGIN IF(@intRecordOfPage=0) SELECT TOP 10 ID,Type,FaxName, PostDate,Author,Content FROM FaxOfSchool ORDER   BY PostDate DESC ELSE BEGIN SET ROWCOUNT @intRecordOfPage SELECT ID,Type,FaxName,PostDate,Author FROM FaxOfSchool WHERE [url=mailto:Type=@intType]Type=@intType END END ELSE --·­Ò³Ê± BEGIN SET @intRecordNumber=(SELECT COUNT(*)     FROM FaxOfSchool     WHERE [url=mailto:Type=@intType]Type=@intType ) --ÐÞÕýÊä³öµÄÆðʼÐкŠIF (@intRecordOfPage * @intPageNo> @intRecordNumber) SET @intTop = @intRecordNumber % @intRecordOfPage ELSE SET @intTop = @intRecordNumber-(@intRecordOfPage * (@intPageNo-1)) --²åÈëÊý¾Ý»º´æ±í SET ROWCOUNT @intTop INSERT INTO @cacheTopicListTable( [ID],         Type,         LawName,       PostDate,       Author           )   SELECT   [ID],   Type,   FaxName,   PostDate,   Author FROM FaxOfSchool WHERE [url=mailto:Type=@intType]Type=@intType SET ROWCOUNT @intRecordOfPage SELECT   [ID],   Type,   LawName AS FaxName,   PostDate,   Author FROM @cacheTopicListTable ORDER BY [ID] Desc END END   ELSE IF(@intCategoryID=27) /*´ÓCollegueOfHeNan±íÖÐÈ¡Êý¾Ý */ BEGIN IF(@bitIsMore=0) --²»·­Ò³Ê± BEGIN IF(@intRecordOfPage=0) SELECT TOP 8 [ID],Type,AcademyName,Homepage,Range FROM CollegueOfHeNan ELSE BEGIN SET ROWCOUNT @intRecordOfPage SELECT   [ID],Type,AcademyName,Homepage,Range FROM CollegueOfHeNan WHERE [url=mailto:Type=@intType]Type=@intType END END ELSE --·­Ò³Ê± BEGIN SET @intRecordNumber=(SELECT COUNT(*)     FROM CollegueOfHeNan     WHERE [url=mailto:Type=@intType]Type=@intType ) --ÐÞÕýÊä³öµÄÆðʼÐкŠIF (@intRecordOfPage * @intPageNo> @intRecordNumber) SET @intTop = @intRecordNumber % @intRecordOfPage ELSE SET @intTop = @intRecordNumber-(@intRecordOfPage * (@intPageNo-1)) --²åÈëÊý¾Ý»º´æ±í SET ROWCOUNT @intTop INSERT INTO @cacheTopicListTable( [ID],         Type,         LawName,       Homepage,       Range           )   SELECT   [ID],   Type,   AcademyName,   Homepage,   Range FROM CollegueOfHeNan WHERE [url=mailto:Type=@intType]Type=@intType SET ROWCOUNT @intRecordOfPage SELECT   [ID],   Type,   LawName AS AcademyName,   Homepage,   Range FROM @cacheTopicListTable ORDER BY [ID] Desc END END ELSE IF(@intCategoryID=28) /*´ÓOrgnizationOfEdun±íÖÐÈ¡Êý¾Ý */ BEGIN IF(@bitIsMore=0) --²»·­Ò³Ê± BEGIN IF(@intRecordOfPage=0) SELECT TOP 8 ID,Type,OrgnizationName,Homepage FROM OrgnizationOfEdu ELSE BEGIN SET ROWCOUNT @intRecordOfPage SELECT ID,Type,OrgnizationName,Homepage FROM OrgnizationOfEdu WHERE [url=mailto:Type=@intType]Type=@intType END END ELSE --·­Ò³Ê± BEGIN SET @intRecordNumber=(SELECT COUNT(*)     FROM OrgnizationOfEdu     WHERE [url=mailto:Type=@intType]Type=@intType ) --ÐÞÕýÊä³öµÄÆðʼÐкŠIF (@intRecordOfPage * @intPageNo> @intRecordNumber) SET @intTop = @intRecordNumber % @intRecordOfPage ELSE SET @intTop = @intRecordNumber-(@intRecordOfPage * (@intPageNo-1)) --²åÈëÊý¾Ý»º´æ±í SET ROWCOUNT @intTop INSERT INTO @cacheTopicListTable( [ID],         Type,         LawName,       Homepage     )   SELECT   [ID],   Type,   OrgnizationName,   Homepage FROM OrgnizationOfEdu WHERE [url=mailto:Type=@intType]Type=@intType SET ROWCOUNT @intRecordOfPage SELECT   [ID],   Type,   LawName AS OrgnizationName,   Homepage FROM @cacheTopicListTable ORDER BY [ID] Desc END END SELECT @intRecordNumber BB [/pre][pre] [/pre][pre] [/pre][pre] [/pre][pre] [/pre][pre]GO [/pre]