DIV class=guanggao><SPAN id=contentAdv></SPAN></DIV><SPAN class=t18>
<P>2000:</P>
<P>  首先获得所有的记录集合的存储过程:</P>
<P>create   PROCEDURE [dbo].[P_GetOrderNumber]<BR>AS<BR> select count(orderid) from orders;----orders为表<BR> RETURN</P>
<P>分页的存储过程</P>
<P>create  procedure [dbo].[P_GetPagedOrders2000]<BR>(@startIndex int,  ---开始页数<BR>@pageSize int----每一页显示的数目<BR>)<BR>as<BR>set nocount on<BR>declare @indextable table(id int identity(1,1),nid int)  ----定义一个表变量<BR>declare @PageUpperBound int<BR>set @PageUpperBound=@startIndex+@pagesize-1<BR>set rowcount @PageUpperBound<BR>insert into @indextable(nid) select orderid from orders order by orderid desc<BR>select O.orderid,O.orderdate,O.customerid,C.CompanyName,E.FirstName+' '+E.LastName as EmployeeName <BR>from orders O<BR>left outer join Customers C<BR>on O.CustomerID=C.CustomerID<BR>left outer join Employees E<BR>on O.EmployeeID=E.EmployeeID<BR>inner join @indextable t on <BR>O.orderid=t.nid<BR>where t.id between @startIndex and @PageUpperBound order by t.id    ----实现分页的关键<BR>set nocount off</P>
<P><BR>2005:</P>
<P>create  [dbo].[P_GetPagedOrders2005]<BR>(@startIndex INT, <BR> @pageSize INT<BR> )<BR>AS<BR>begin<BR>WITH orderList AS ( <BR>SELECT ROW_NUMBER() OVER (ORDER BY O.orderid DESC)AS Row, O.orderid,O.orderdate,O.customerid,C.CompanyName,E.FirstName+' '+E.LastName as EmployeeName <BR>from orders O<BR>left outer join Customers C<BR>on O.CustomerID=C.CustomerID<BR>left outer join Employees E<BR>on O.EmployeeID=E.EmployeeID)</P>
<P>SELECT orderid,orderdate,customerid,companyName,employeeName<BR>FROM orderlist<BR>WHERE Row between @startIndex and @startIndex+@pageSize-1<BR>end</P></SPAN><script language='javascript' src='http://www.iTbulo.com/gg/200703/79.js'></script></td>
</tr>
</table><!--c-pip文章正文中间240*200--><SPAN id=span_ad3>
<SCRIPT language=JavaScript>
document.write("<script src=\"http://www.iTbulo.com/gg/200703/78.js\"><\/script>");</SCRIPT>
</SPAN>
<SCRIPT>
document.getElementById("contentAdv").innerHTML=document.getElementById("span_ad3").innerHTML;
document.getElementById("span_ad3").innerHTML="";
</SCRIPT>
</td>
<td width="1" valign="top" bgcolor="#A8A8A8"></td>
<td width="173" valign="top" bgcolor="F3F3F3">
<table width="100%" border="0" cellspacing="0" cellpadding="0" align="center">
<tr>
<td height="21" align="center" valign="middle" bgcolor="DFDFDF"><strong>文章搜索</strong></td>
</tr>
<tr>
<td height="2" bgcolor="A3A3A3"></td>
</tr>
<form method="Get" name="SearchForm" action="/Search.asp" target="_blank"><TR>
<TD height="40" align=center><input name="Field" type="hidden" id="Field" value="Title"><INPUT name=Keyword id="Keyword" size=16> <INPUT type=submit value=搜索 name=submit onClick="if(this.form.Keyword.value=='') {alert('请输入关键字');return false;}"></TD></TR></FORM>
<tr>
<td height="21" align="center" valign="middle" bgcolor="DFDFDF"><strong>