请教存储过程的多个输出
ALTER   PROCEDURE   [dbo].[select_stu_Valid]
(
@UserId   varchar(50),
@ISValid   varChar(12)   OUTPUT)
AS
IF   EXISTS(SELECT   s_userguid   FROM   mytable   WHERE   s_userguid   =   @UserId)
SELECT   @ISValid   =   'yes '
ELSE
SELECT   @ISValid   =   'no '
这个存储过程是意思是判断s_userguid   是否为空。为空的话输出no，不为空的话输出yes。
但是我想在这个存储过程中如果s_userguid   非空的话再将一个字段s_ID   取出，这样的话应该怎么改写呢？

------解决方案--------------------
SELECT ISValid = 'no ', s_ID
FROM mytable
------解决方案--------------------
ALTER PROCEDURE [dbo].[select_stu_Valid]
(
@UserId varchar(50)
AS
IF EXISTS(SELECT s_userguid FROM mytable WHERE s_userguid = @UserId)
SELECT 'yes ', s_ID FROM mytable WHERE s_userguid = @UserId
ELSE
SELECT 'no '

------解决方案--------------------

ALTER PROCEDURE [dbo].[select_stu_Valid]
(
@UserId varchar(50),
@s_ID varchar(50) output,
@ISValid varChar(12) OUTPUT)
AS
IF EXISTS(SELECT s_userguid ,@s_ID=s_ID FROM mytable WHERE s_userguid = @UserId)
SELECT @ISValid = 'yes '
ELSE
SELECT @ISValid = 'no '