Sybase are aceeași sintaxă de caz ca SQL Server:
Descriere
Sprijină expresii SQL condiționate; poate fi folosit oriunde se poate folosi o expresie de valoare.
Sintaxă
caz
cand SEARCH_CONDITION apoi expresie
[cand SEARCH_CONDITION apoi expresie]...
[else expresie]
end
caz and values Sintaxă
caz expresie
cand expresie apoi expresie
[cand expresie apoi expresie]...
[else expresie]
end
Parametrii
caz
begins the caz expresie.
cand
precede condiția de căutare sau expresia care trebuie comparată.
SEARCH_CONDITION
is used to set conditions for the results that are selected. Search conditions for caz expresies are similar to the search conditions in a where clause. Search conditions are detailed in the Transact-SQL User?s Guide.
apoi
precedes the expresie that specifies a result value of caz.
expresie
is a column name, a constant, a function, a subquery, or any combination of column names, constants, and functions connected by arithmetic or bitwise operators. For more information about expresies, see ?expresies? in.
Exemplu
select disaster,
caz
cand disaster = "earthquake"
apoi "stand in doorway"
cand disaster = "nuclear apocalypse"
apoi "hide in basement"
cand monster = "zombie apocalypse"
apoi "hide with Chuck Norris"
else
apoi "ask mom"
end
from endoftheworld