by darkload [SQL Query] [2018.01.31 16:43:48]
mssql 에서 0,1을 yes,no로 표현을 어떻게 하나요?
WITH t AS ( SELECT 1 idx, 1 flag UNION ALL SELECT 2, 0 ) SELECT idx , flag , CASE flag WHEN 1 THEN 'yes' ELSE 'no' END AS yn FROM t ;