RETURN Statement

Causes an immediate exit from a called procedure.

Syntax

RETURN {expression}

Syntax Elements

expression
Any valid SQL expression that evaluates to a single (scalar) value with a data type that is compatible with the declared return value of the procedure.

Comments

Any statements following the RETURN statement are skipped.

Example

CREATE PROC EX7(@TYPE INTEGER IN) RETURNS DECIMAL(6,2) AS

BEGIN

    DECLARE @V DECIMAL(6,2)

    IF @TYPE=1

        SET @V = (SELECT MIN(AMT) FROM TESTDATA)

    ELSE IF @TYPE=2

        SET @V = (SELECT MAX(AMT) FROM TESTDATA)

    ELSE

        SET @V = (SELECT AVG(AMT) FROM TESTDATA)

    RETURN @V

END

Creates a procedure called EX7 that returns the minimum, maximum or average value from the AMT column of the TESTDATA table, depending on the value of the @TYPE parameter.

See Also

CREATE PROCEDURE statement.