sql-server - MSSQL WHERE 与 IF

Question

我正在尝试获取执行以下操作的查询:

SELECT * FROM Test
WHERE
IF Condition = True
    Column1 = 'This'
    Column2 = 'That'
ELSE
    Column3 = 'This'
    column4 = 'That'

我可以在 where 子句中找到 If 条件的唯一内容是 CASES。我找不到一个允许多个条件的案例的示例。

到目前为止，我必须通过在 SELECT 语句之外使用 If 并复制语句但更改 WHERE 子句来实现这一点。

Answer 1

SELECT * FROM Test
WHERE
(Condition = True
    AND Column1 = 'This'
    AND Column2 = 'That')
OR
(Condition = FALSE
    AND Column3 = 'This'
    AND column4 = 'That')