当存储过程里有两个查询语句时，可以调用么？如果可以怎样调用？？？

[yaoming2002]

CREATE PROCEDURE SPSHOWyear
AS
select total,theyear from yearcount order by theyear
select max(total) maxt from yearcount
return
GO

这个存储过程，能调用么？如果能，怎么调用？谢谢

[tripofdream]

......
set rs=cmd.execute(SPSHOWyear)
'......操作第一个记录集（跟普通的recordset一样）
set rs=rs.nextrecordset
'......操作第二个记录集

[online]

在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")