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
Post a Comment