1.select flag = case flag when 0 then '有效' when 9 then '删除' else '其他' end from Article
2.select case flag when 0 then '有效' when 9 then '删除' else '其他' end as flag from Article
1.select flag = case flag when 0 then '有效' when 9 then '删除' else '其他' end from Article
2.select case flag when 0 then '有效' when 9 then '删除' else '其他' end as flag from Article