Usage of "case...end" in SQL Server

In SQL Server Case...end statements, there are generally two ways to use:

1, equivalent to C # in If...else, example:

1 SelectCName, Title= Case2                  whenClevel='A1'  Then 'Junior Programmer'3                  whenClevel='A2'  Then 'Intermediate Programmer'4                  whenClevel='A3'  Then 'Senior Programmer'5                 Else 'Master of the Ashes level'6             End7  fromCoder

This notation can be used to make intervals or equivalent judgments.

2, equivalent to Switch...case in C #, for example:

1 SelectCName, Title= CaseClevel2                  when 'A1'  Then 'Junior Programmer'3                  when 'A2'  Then 'Intermediate Programmer'4                  when 'A3'  Then 'Senior Programmer'5                 Else 'Master of the Ashes level'6             End7  fromCoder

This type of writing can only be used to make equivalent judgments.

Note : In the Case...end statement, then the data type of the then face value must be consistent.

Usage of "case...end" in SQL Server