首先是创建一个表:table
包括的字段有:Title,XinGMing,MYD,MYDDZ_Note,MYDDZ_RDT,FlowEmps,
将MYD的值0,1,2转换为:满意,一般,不满意
select [Title],[XingMing],case when MYD = 0 then '满意' when MYD = 2 then '不满意' when MYD = 1 then '一般' when MYD = null then ''end ,[MYDDZ_Note],[MYDDZ_RDT],[FlowEmps]
FROM table