28,403
社区成员
发帖
与我相关
我的任务
分享当存储过程里有两个查询语句时，可以调用么？如果可以怎样调用？？？
CREATE PROCEDURE SPSHOWyear
AS
select total,theyear from yearcount order by theyear
select max(total) maxt from yearcount
return
GO
这个存储过程，能调用么？如果能，怎么调用？谢谢
AS
select total,theyear from yearcount order by theyear
select max(total) maxt from yearcount
return
GO
这个存储过程，能调用么？如果能，怎么调用？谢谢
...全文
请发表友善的回复…
发表回复
online 2002-07-23
- 打赏
- 举报
在sp种
select @total=total,@theyear=theyear from yearcount order by theyear
select @s=max(total) from yearcount
select @total as total,@theyear as theyear,@s as maxt
在asp种直接用
rs.fields("total")
rs.fields("theyear")
rs.fields("maxt")
select @total=total,@theyear=theyear from yearcount order by theyear
select @s=max(total) from yearcount
select @total as total,@theyear as theyear,@s as maxt
在asp种直接用
rs.fields("total")
rs.fields("theyear")
rs.fields("maxt")
tripofdream 2002-07-23
- 打赏
- 举报
......
set rs=cmd.execute(SPSHOWyear)
'......操作第一个记录集（跟普通的recordset一样）
set rs=rs.nextrecordset
'......操作第二个记录集
set rs=cmd.execute(SPSHOWyear)
'......操作第一个记录集（跟普通的recordset一样）
set rs=rs.nextrecordset
'......操作第二个记录集
