SQL Server 2000和 SQL Server 2005实现分页的方式

O.orderid=t.nid

where t.id between @startIndex and @PageUpperBound order by t.id ----实现分页的关键

set nocount off

2005:

create [dbo].[P_GetPagedOrders2005]

(@startIndex INT,

@pageSize INT

)

AS

begin

WITH orderList AS (

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

from orders O

left outer join Customers C

on O.CustomerID=C.CustomerID

left outer join Employees E

on O.EmployeeID=E.EmployeeID)

SELECT orderid,orderdate,customerid,companyName,employeeName

FROM orderlist

WHERE Row between @startIndex and @startIndex+@pageSize-1

end