select State=case when State=1 then '无返回值'
when State=2 then '不可测值'
when State=3 then '未工作'
else'正常' end,
[value]=case when State=1 then '无返回值'
when State=2 then '不可测值'
when State=3 then '未工作'
else [value] end
from 表
Select
(Case State When 1 Then N'无返回值' When 2 Then N'不可测值' When 3 Then '未工作' Else N'正常' End ) As State,
(Case State When 1 Then N'无返回值' When 2 Then N'不可测值' When 3 Then '未工作' Else Rtrim(Value) End ) As Value
From TableName
select State=case when State=1 then '无返回值'
when State=2 then '不可测值'
when State=3 then '未工作'
else'正常' end,
[value]=case when State=1 then '无返回值'
when State=2 then '不可测值'
when State=3 then '未工作'
else [value] end
from 表
select
state = case
when state=1 then '无返回值'
when state-21 then '不可测值'
when state-3 then '未工作'
else '正常' end,
[value] = case
when state=1 then '无返回值'
when state-21 then '不可测值'
when state-3 then '未工作'
else cast([value] as varchar) end
from tb