--select DataName ,
--case Code
--
-- when 'W01' then '男'
--
-- when 'W07' then '女'
--
-- else '其他'
--
-- end as Code
--from dbo.HistoryData
select DataName,
(
case
when Code='W01' then '男'
when Code='W07' then '女'
else '其他'
end
)
from HistoryData