我正在尝试在SQL查询的where子句中添加一个case或if语句。
我有一个包含起始日期和结束日期以及每天表示旅程发生地点的布尔字段的旅行时间表。这是我目前的代码,但是我得到了错误的语法错误:
declare @date datetime
set @Date = '05/04/2012'
declare @day nvarchar(50)
set @day = 'Monday'
Select * From Times
WHERE (StartDate <= @Date) AND (EndDate >= @Date)
CASE WHEN @day = 'Monday' THEN
AND (Monday = 1)
WHEN @day = 'Tuesday' THEN
AND (Tuesday = 1)
ELSE
AND (Wednesday = 1)
END