TSQL 和 casewhen 与多个when？

发布于 2024-12-10 00:07:36 字数 454 浏览 0 评论 0原文

我有几个条件，这些条件的结果应该是相同的。我在网上搜索并发现了这样的东西：

CASE ProductLine
     WHEN 'R' THEN 'Road'
     WHEN 'M' THEN 'Mountain'
     WHEN 'T' THEN 'Touring'
     WHEN 'S' THEN 'Other sale items'
     ELSE 'Not for sale'
  END

这很好，但不是我需要的，对我来说它更像是 R、M、T 和 S 都有相同的结果，而 A、B、C、D 例如没有。我该怎么做？我无法与 OR 连接，或者至少我没有成功:)。也许是这样的？

CASE ProductLine
     WHEN 'R' OR 'M' OR ... THEN 'Road'
     ELSE 'Not for sale'
  END

原文

I have several conditions and the result for those should be the same. I searched the net and found stuff like this:

CASE ProductLine
     WHEN 'R' THEN 'Road'
     WHEN 'M' THEN 'Mountain'
     WHEN 'T' THEN 'Touring'
     WHEN 'S' THEN 'Other sale items'
     ELSE 'Not for sale'
  END

That's nice, but not what I need, for me its more like R,M,T and S all have the same result and A,B,C,D for example don't have. How would I do this? I cant connect with OR, or at least I did not manage to :). Something like this maybe?

CASE ProductLine
     WHEN 'R' OR 'M' OR ... THEN 'Road'
     ELSE 'Not for sale'
  END

分享到QQ

分享到微博

如果你对这篇内容有疑问，欢迎到本站社区发帖提问参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。

发布评论

需要登录才能够评论，你可以免费注册一个本站的账号。

傲娇萝莉攻 2024-12-17 00:07:36

更改为“搜索”CASE 表达式。上面有一个“简单”的 CASE 表达式

CASE
   WHEN  ProductLine IN ('R', 'M', ...) THEN 'Road'
   ELSE 'Not for sale'
END

从上面的 MSDN 链接：

Simple CASE expression: 
CASE input_expression 
     WHEN when_expression THEN result_expression [ ...n ] 
     [ ELSE else_result_expression ] 
END 

Searched CASE expression:
CASE
     WHEN Boolean_expression THEN result_expression [ ...n ] 
     [ ELSE else_result_expression ] 
END

Change to a "searched" CASE expression. You have a "simple" CASE expression above

CASE
   WHEN  ProductLine IN ('R', 'M', ...) THEN 'Road'
   ELSE 'Not for sale'
END

From the MSDN link above:

Simple CASE expression: 
CASE input_expression 
     WHEN when_expression THEN result_expression [ ...n ] 
     [ ELSE else_result_expression ] 
END 

Searched CASE expression:
CASE
     WHEN Boolean_expression THEN result_expression [ ...n ] 
     [ ELSE else_result_expression ] 
END

回复收藏 0 原文

~没有更多了~