Kontrollstrukturen in SQLScript

Beispiele für Kontrollstrukturen in SQLScript:

If-Then-Else

Is represented in SQL with CASE-WHEN-ELSE:

CASE-WHEN-ELSE

CASE
    WHEN condition1 THEN result1
    WHEN condition2 THEN result2
    WHEN conditionN THEN resultN
    ELSE result
END;