Simple CASE statement, see ITERATE. Searched CASE statement, see ITERATE. IF-THEN-ELSEIF-ELSE statement, see IF. Examples and rules governing exception conditions, see DDL Statements in Stored Procedures.