Documentation Comments
Use this form to comment on this topic. You can also provide any general observations about the Online Documentation, or request that additional information be added in a future release.
RealityV15.1Online Documentation (MoTW) Revision 7
SET Statement (SQL) (m691509+set.htm)
Assigns a value to a variable or procedure argument.
SET varname = expression
varname
The name of the variable or procedure argument.
expression
An SQL expression. The value that results from evaluating the expression is
assigned to the specified variable or argument.
Local variables must be declared before they can be used.
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.
DECLARE statement, CREATE PROCEDURE statement.