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

Question

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

错误：

Missing or incomplete select statement

Answer 1

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

即，

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. 

试试这个。