ALTERPROCEDURE P_GetOrderNumber AS selectcount(orderid) from orders; RETURN
ALTERprocedure P_GetPagedOrders2000 (@startIndexint, @pageSizeint ) as set nocount on declare@indextabletable(id intidentity(1,1),nid int) declare@PageUpperBoundint set@PageUpperBound=@startIndex+@pagesize-1 setrowcount@PageUpperBound insertinto@indextable(nid) select orderid from orders orderby orderid desc select O.orderid,O.orderdate,O.customerid,C.CompanyName,E.FirstName+''+E.LastName as EmployeeName from orders O leftouterjoin Customers C on O.CustomerID=C.CustomerID leftouterjoin Employees E on O.EmployeeID=E.EmployeeID innerjoin@indextable t on O.orderid=t.nid where t.id between@startIndexand@PageUpperBoundorderby t.id set nocount off RETURN
ALTERPROCEDURE P_GetPagedOrders2005 (@startIndexINT, @pageSizeINT ) AS begin WITH orderList AS ( SELECT ROW_NUMBER() OVER (ORDERBY O.orderid DESC)AS Row, O.orderid,O.orderdate,O.customerid,C.CompanyName,E.FirstName+''+E.LastName as EmployeeName from orders O leftouterjoin Customers C on O.CustomerID=C.CustomerID leftouterjoin Employees E on O.EmployeeID=E.EmployeeID) SELECT orderid,orderdate,customerid,companyName,employeeName FROM orderlist WHERE Row between@startIndexand@startIndex+@pageSize-1 end
posted on
2007-07-16 13:01刺猬博客
阅读(1216)
评论(0)
编辑收藏举报