SQL SELECT - 根据条件返回布尔值 [英] SQL SELECT - Return boolean based on condition

问题描述

基本上我正在尝试这样做

Essentially I'm trying to do this

select  u.Hostname, u.IsCustom, (u.Status = 5) as IsActive
from    SiteUrlMappings u

其中 5 是表示活动"网址的 int.

Where 5 is an int representing an "Active" url.

这当然不行，我的sql像旧螺丝刀一样生锈了.

Of course this doesn't work, and my sql is rusty like an old screwdriver.

推荐答案

你不需要 CASE 表达式
只需利用 bit 的工作原理:所有非零值在转换为 bit 时都为 1

You don't need a CASE expression
Just leverage how bit works: all non-zero values give 1 when cast to bit

SELECT
    u.Hostname,
    u.IsCustom,
    ~ CAST((u.Status - 5) AS bit) AS IsActive
from    SiteUrlMappings u

这篇关于SQL SELECT - 根据条件返回布尔值的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！