create view test_sp
as
select cast(case when isnull(nt,0)=0 then 1 else 0 end as bit)
from 表
注：sqlserver bit 类型 只有0和1,没有false和true，如果你要用f和t，换成varchar就可以了
cast( case when isnull(nt,0.0000) = 0.0000 then true else false end as bit ) as nt
内容全部来源于网络收集，如有侵权，请联系网站删除：QQ：24596024