查询语句为:sql="select distinct 产品.物品名称 as 名称,库存.合库存量 from 库存 inner join 产品 on 库存.产品ID=产品.产品ID order by 产品.产品ID asc"
你的存储过程后几句的格式为如下:
insert into @indextable(nid) select 产品.产品ID from 库存 inner join 产品 on 库存.产品ID=产品.产品ID order by 产品.产品ID desc
select O.名称 from 库存 O,@indextable t where O.产品.产品ID=t.nid
and t.id>@PageLowerBound and t.id<=@PageUpperBound order by t.id
上面的select O.名称 from 库存 O join 产品 on 库存.产品ID=产品.产品ID ,@indextable t where O.产品.产品ID=t.nid对吗,改为select O.名称 from 库存 O ,@indextable t where O.产品.产品ID=t.nid对吗,请作答。能不能给一个完整的答案。
你的存储过程后几句的格式为如下:
insert into @indextable(nid) select 产品.产品ID from 库存 inner join 产品 on 库存.产品ID=产品.产品ID order by 产品.产品ID desc
select O.名称 from 库存 O,@indextable t where O.产品.产品ID=t.nid
and t.id>@PageLowerBound and t.id<=@PageUpperBound order by t.id
上面的select O.名称 from 库存 O join 产品 on 库存.产品ID=产品.产品ID ,@indextable t where O.产品.产品ID=t.nid对吗,改为select O.名称 from 库存 O ,@indextable t where O.产品.产品ID=t.nid对吗,请作答。能不能给一个完整的答案。
CREATE procedure rrr
(@pagesize int,
@pageindex int,
@docount bit)
as
set nocount on
if(@docount=1)
select count(newsid) from artitle
else
begin
declare @indextable table(id int identity(1,1),nid int)
declare @PageLowerBound int
declare @PageUpperBound int
set @PageLowerBound=(@pageindex-1)*@pagesize
set @PageUpperBound=@PageLowerBound+@pagesize
set rowcount @PageUpperBound
insert into @indextable(nid) select newsid from artitle order by dateandtime desc
select O.newsid,O.title, O.typename,O.dateandtime from artitle O,@indextable t where O.newsid=t.nid
and t.id>@PageLowerBound and t.id<=@PageUpperBound order by t.id
end
set nocount off
GO
上面的查询句为:select count(newsid) from artitle ,我想改为:sql="select distinct 产品.物品名称 as 名称,库存.合库存量 from 库存 inner join 产品 on 库存.产品ID=产品.产品ID order by 产品.产品ID asc"