select MEAS1,MEAS2,MEAS3=case when MEAS3=0 then 1 else MEAS3 end from tb
select MEAS1,MEAS2, case MEAS3 when 0 then 1 else MEAS3 end as MEAS3 from NH_MEAS_OTHER
select MEAS1,MEAS2, case MEAS3 when 0 then 1 else MEAS3 end as MEAS3 from NH_MEAS_OTHER
select isnull(nullif(meas3,0),1) from [Table]
case when判断下 select MEAS1,MEAS2, case MEAS3 when 0 then 1 else MEAS3 end as MEAS3 from NH_MEAS_OTHER
select MEAS1,MEAS2,CASE WHEN MEAS3=0 THEN 1 ELSE MEAS3 END AS MEAS3 from NH_MEAS_OTHER
select MEAS1,MEAS2,MEAS3=case meas3 when 0 then 1 else meas3 end from NH_MEAS_OTHER --or select MEAS1,MEAS2,MEAS3=isnull(nullif(meas3,0),1) from NH_MEAS_OTHER
---1 select MEAS1,MEAS2, case MEAS3 when 0 then 1 else MEAS3 end as MEAS3 from NH_MEAS_OTHER ---2 select MEAS1,MEAS2,isnull(nullif(meas3,0),1) as MEAS3 from NH_MEAS_OTHER
select MEAS1,MEAS2,isnull(nullif(meas3,0),1) as MEAS3 from NH_MEAS_OTHER
from tb
case MEAS3 when 0 then 1 else MEAS3 end as MEAS3
from NH_MEAS_OTHER
case MEAS3 when 0 then 1 else MEAS3 end as MEAS3
from NH_MEAS_OTHER
select MEAS1,MEAS2,
case MEAS3 when 0 then 1 else MEAS3 end as MEAS3
from NH_MEAS_OTHER
select MEAS1,MEAS2,MEAS3=case meas3 when 0 then 1 else meas3 end from NH_MEAS_OTHER --or
select MEAS1,MEAS2,MEAS3=isnull(nullif(meas3,0),1) from NH_MEAS_OTHER
select
MEAS1,MEAS2,
case MEAS3 when 0 then 1 else MEAS3 end as MEAS3
from
NH_MEAS_OTHER
---2
select
MEAS1,MEAS2,isnull(nullif(meas3,0),1) as MEAS3 from NH_MEAS_OTHER