22,209
社区成员
发帖
与我相关
我的任务
分享
select
case
when isnumeric(h.u_secondunit)=1 then cast(h.U_SecondUnit as numeric)
else 0
end
from [@ava_oime] h
select CASE WHEN ISNUMERIC(H.U_SECONDUNIT)=1 THEN cast(h.U_SecondUnit as numeric) ELSE NULL END
from [@ava_oime] h
select h.U_SecondUnit
from [@ava_oime] h
where isnumeric(h.u_secondunit) =0
select cast(U_SecondUnit as numeric)
from (
select *
from [@ava_oime] h
where isnumeric(h.u_secondunit) =1
) as t
这样呢?select h.U_SecondUnit
from [@ava_oime] h
where isnumeric(h.u_secondunit) =0