SQL Server查询错误：“缺少或不完整的SELECT语句”(SQL Server query

SELECT 
    Id, Product, 
    [fare] = CASE WHEN @date BETWEEN s1from AND s1to THEN s1rate ELSE fare 
FROM Table1

错误：

缺失或不完整的SELECT语句

Answer 1:

难道你忘了在CASE语句结束END关键字？

IE浏览器。

SELECT 
    Id, Product, 
    [fare] = CASE WHEN @date BETWEEN s1from AND s1to THEN s1rate ELSE fare END
FROM Table1

Answer 2:

尝试

SELECT Id, Product, [fare] =
CASE @date
WHEN BETWEEN s1from AND s1to THEN s1rate 
ELSE fare
END
FROM Table1

Answer 3:

该查询可能是这样的，

Select Id, Product, (case when @date between s1from and s1to then s1rate else fare end)as fare from  Table1.

尝试这个。

文章来源: SQL Server query error: “Missing or incomplete select statement”