选择字符串比较作为tsql中的布尔值

我会用案例陈述

Select name, case when status = 'current' then 1 else 0 end as IsValid
from items

试试这个-

select name, 
(CASE status WHEN 'current' THEN 1 Else 0 END) as IsValid 
from items

select name, IIF(status = 'current', 1, 0) as IsValid
from items