关于ASP取SQL SERVER存储过程返回值的问题
CREATE   PROCEDURE   Initialize  
@UserID   int
AS

Declare   @Edition   varchar(10)


SET   NOCOUNT   ON
Begin

Select   Top   1   @Edition=Edition   From   Edition

IF   @UserID= '100000 '
Begin
Select   @UserID=Max(UserID)   From   UserID
Set   @UserID=@UserID+1
Insert   Into   UserID   (UserID)   Values   (@UserID)
End

Select   FirstClassID,FirstClassShow   from   FirstClass   where   IsShow=1   Order   by   OrderNum  

Select   @Edition,@UserID
End
SET   NOCOUNT   OFF
GO


我想在ASP页面调用此存储过程后能够得到@Edition,@UserID这两个变量的值，还有Select   FirstClassID,FirstClassShow   from   FirstClass   where   IsShow=1   Order   by   OrderNum   这个记录集，要怎么写存储过程呢？ASP端怎么收呢？还有大家看我这存储过程哪写的不合理，可以改进，也请帮助说明一下，谢谢了！

------解决方案--------------------
把那俩参数合并到记录集里去
------解决方案--------------------
http://www.baidu.com/s?ie=gb2312&bs=asp&sr=&z=&cl=3&f=8&wd=asp+%B4%E6%B4%A2%B9%FD%B3%CC+%CA%E4%B3%F6%B2%CE%CA%FD&ct=0