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
IF/ELSE Statement (SQL) (m691509+if.htm)
Allows conditional execution of SQL statements.
IF condition statement1 { ELSE statement2 }
condition
An SQL Search Condition.
statement1, statement2
A single SQL statement, or a group of statements enclosed in the
BEGIN and END
keywords.
statement1 is executed only if condition evaluates to true. If an ELSE clause is included and condition evaluates to false, statement2 is executed.
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.