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.