SET

When constructing the body of an SQL procedure, you can use a SET assignment statement to write the value of an expression to a variable or parameter.

Syntax

SET { parameter_name | variable_name } = expression

You can assign a value to a parameter, variable, or a row reference in a FOR EACH ROW loop.

The expression is any valid expression.

Note: The value returned by the expression must be of a type compatible with the variable into which you write the value.