ALTER procedure P_GetPagedOrders2000
(@startIndex int,
@endIndex int
)
as
set nocount on
declare @indextable table(id int identity(1,1),nid int)
set rowcount @endIndex
insert into @indextable(nid) select orderid from orders order by orderid desc
select 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
inner join @indextable t on
O.orderid=t.nid
where t.id between @startIndex and @endIndex order by t.id
set nocount off
RETURN
这是个分页控件的存储过程,看不懂里面的东东 大牛们帮忙可以改成sql语句吗
解决方案 »
- ACCESS中如何在一个查询生成表中 增加一列编号
- 帮忙看看这个语句,为什么不能实现
- GRANT 授权问题,高手请进!!急.......
- SQL 2005 Express 安装失败
- 有个数据库的表,需用Excel要往里面导入数据,怎么实现?
- 大力快帮帮我??
- 请问我想在怎么直接执行SQL的函数,(不放在select 等DML语句中)
- transact-sql可以讲一个表中的数据写到硬盘上某个文件里面吗?
- 树形数据的处理__之后的问题?????
- sql 有没有函数根据日期判断是否为法定节假日或者春节
- SQL区分大小写
- OPENQUERY 和 OPENROWSET 获得的结果集中不允许有重复的列名(奇怪的报错)
declare @startIndex int
declare @endIndex int
set @startIndex=11
set @endIndex=20set nocount on
declare @indextable table(id int identity(1,1),nid int)
set rowcount @endIndex
insert into @indextable(nid) select orderid from orders order by orderid desc
select 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
inner join @indextable t on
O.orderid=t.nid
where t.id between @startIndex and @endIndex order by t.id
set nocount off