sqlserver case when使用

因为zx_fk如果为零 作为除数就会报错。

如果T.zx_fk  =0 则返回0否则 执行 select zx_sfje/zx_fk from tys_mxys where id='7A54F1F8-64B5-41C2-85E6-88D92327C996'

select
case  T.zx_fk
when  0 then 0
else (select zx_sfje/zx_fk from tys_mxys where id='7A54F1F8-64B5-41C2-85E6-88D92327C996')*100
end
from (select zx_fk from tys_mxys where id='7A54F1F8-64B5-41C2-85E6-88D92327C996' ) T

转载于:https://www.cnblogs.com/easyunion/p/9871413.html