[Mssql] CASE WHEN THEN

CASE문에 직접 컬럼넣는 방법(switch case느낌)

SELECT *,
    CASE birthMonth
        WHEN 1 THEN N'겨울'
        WHEN 2 THEN N'봄'
    END AS birthSeason
FROM dbo.players;

WHEN조건에 컬럼 조건 넣는 방법(if else 느낌)

SELECT
  CASE
	WHEN birthMonth <4 THEN N'겨울'
  END
FROM dbo.players