且构网

分享程序员开发的那些事...
且构网 - 分享程序员编程开发的那些事

如何创建条件 WHERE 子句?

更新时间:2021-06-29 04:06:04

你能不能做到以下几点?

Could you just do the following?

SELECT
    *
FROM
    Table
WHERE
    (@booleanResult = 1
    AND Column1 = 'value1')
OR
    (@booleanResult = 0
    AND Column1 = 'value1'
    AND Column2 = 'value2')