SQLServer Case When Thenマルチ条件判定使用

1 Case ... When ... Then ... End
構文:
Case flag
        When key1 Then value1
        When key2 Then value2 End
例:
sex(性別)は「1」が「男」を表し、「2」が「女」を表す.

select username
    ,pickname
    ,Case sex
        When '1' Then ' '
        When '2' Then ' '
    End As sexName
from users

2 Case ... When ... Then ... Else ... End
構文:
Case
        When expression Then value1
        Else value2 End
例:
sex(性別)は「1」が「男」を表し、その他は「女」を表す.

select username
    ,pickname
    ,Case
        When sex='1' Then ' '
        Else ' '
    End As sexName
from users