sqlserver 三元运算符

sqlserver 三元运算符

三元运算效果

Case when ....... then ....... else ......... end

select row_number() over(  order by UserID desc ) as rn,
(case when Pla_Shop_WxOpenID is null or Pla_Shop_WxOpenID='' then 0 else 1 end ) as IsXiaoChengXu,
UserID,Pla_Shop_WxOpenID, NickName, PicUrl, BID, ParentID
from WxUsers where BID='111' 

 

搜索

复制