sql - sql server中where子句的用例

Question

我想做的是让查询考虑或不考虑日期时间值，这样我就不必在存储过程中执行此操作

if @considerDate =1
    begin
        select * from table 
        where dateCol = @date
    end
else
    begin 
        select * from table
    end

我想做一些类似的事情

select * from table
where   dateCol = ( case 
                    when  @date is not null
                    then @date
            )

在单个查询中

Answer 1

您只需添加END关键字

SELECT * 
FROM    tableName
WHERE   dateCol =   CASE WHEN @considerDate =1
                         THEN @date 
                         ELSE dateCol 
                    END