T-SQL语法问题-在CASE语句中使用OR [英] T-SQL SYNTAX ISSUE - using OR in CASE statement
本文介绍了T-SQL语法问题-在CASE语句中使用OR的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
我想构建一个包含以下逻辑的CASE语句,但是sql编译器不喜欢我的语句中的"OR":
i would like to build a CASE statement that incorporates the following logic, but the sql compiler does not like the 'OR' in my statement:
CASE expression
WHEN expression1 OR expression2
THEN <yadda yadda>
ELSE <yadda yadda>
END
下面的更具体的代码:
CASE @var1
WHEN '99' OR '22'
THEN
(CASE @var2
WHEN 'All' THEN col1
ELSE @var2
END)
END
推荐答案
DECLARE @Variable INT;
SET @Variable = 1;
SELECT
CASE
WHEN @Variable = 1 OR @Variable = 2 THEN 'It is 1 or 2'
WHEN @Variable = 3 THEN 'It is 3'
ELSE 'It is not 1, 2, or 3'
END AS [SomeField]
这篇关于T-SQL语法问题-在CASE语句中使用OR的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文