How to read return code from stored procedure

[Lera]

Hello,
I need to be able to read the code my stored procedure returns.Here is an example of the stored procedure that can return 1, 2, 3, etc depending on input parameter. How can I get the value this stpred procedure returns in ASP?
I tried to use Parameters, but couldn't make it work


Here is sp:
CREATE PROCEDURE Test @Value int
AS
IF @Value = 1
BEGIN
RETURN 1
END

IF @Value = 2
BEGIN
RETURN 2
END

IF @Value = 3
BEGIN
RETURN 3
END

IF @Value NOT BETWEEN 1 AND 3
BEGIN
SELECT 'TEST'
END
GO

I'll appreciate if somebody can help me with it.

Thank you

 

[MapMan]

Try this...

CREATE PROCEDURE Test @Value int
AS
IF @Value = 1
    BEGIN
        SELECT 1
END

IF @Value = 2
    BEGIN
        SELECT 2
END

IF @Value = 3
    BEGIN
        SELECT 3
END

IF @Value NOT BETWEEN 1 AND 3
    BEGIN
        SELECT 'TEST'
END

HTH, MapMan

Assume nothing, question everything, be explicit not implicit, and you'll always be covered.

 

[lpatnaik]

Try this, I am sure it will work.

CREATE PROCEDURE Test
@Value int,
@retVal int output
AS

IF @Value = 1
BEGIN
Set @retval = 1
RETURN
END

IF @Value = 2
BEGIN
Set @retval = 2
RETURN
END

IF @Value = 3
BEGIN
Set @retval = 3
RETURN
END

IF @Value NOT BETWEEN 1 AND 3
BEGIN
SELECT 'TEST'
END

GO



--Lopa