sql server - Using mixture of IF ELSE and OR in an SQL CASE statement -


just want confirm, if correct way in using if else or statement in sql?

case db_name() when 'dbname' 'value1' else 'value2-a' or 'value2-b' 

basically want make statement if dbname correct, take value1, else take either value2-a or value2-b.

i want implement statement in stored procedure.

sql server not have if else or option. each item in select statement needs evaluate 1 value. can't 2 unique values 1 field.

if want have multiple options in case when statement can reuse when keyword.

for example

         select case when db_name() = 'prod' value1               when db_name() = 'dev' value2-a               else value2-b end dbvalue 

Comments