为什么我的Case语句在‘=’附近抛出错误、不正确的语法？

wljmcqd8 于 2022-10-03 发布在其他

关注(0)|答案(2)|浏览(240)

我的Case语句引发此错误的原因：

消息102，级别15，状态1，行2‘=’附近的语法不正确。*

代码：

Create PROCEDURE [dbo].[Chart_SelectSmsComplaintsValidity]

 @FromDate datetime,
 @ToDate datetime

AS
BEGIN

    Select COUNT(ReceivedMessages.ID) As ReceivedMessageID, 
    CASE ReceivedMessages.IsComplaint WHEN ReceivedMessages.IsComplaint=0 
    THEN 'Incomplete'
    WHEN ReceivedMessages.IsComplaint=1 THEN 'Complete'
    WHEN ReceivedMessages.IsComplaint=-3 THEN 'Inappropriate' END from ReceivedMessages 

    where ReceivedMessages.ReceivedDateTime >= @FromDate AND ReceivedMessages.ReceivedDateTime <= @ToDate
    Group By ReceivedMessages.IsComplaint

END

sql-server

来源：https://stackoverflow.com/questions/26851979/why-my-case-statement-throws-error-incorrect-syntax-near

2条答案

按热度按时间

txu3uszq1#

您组合了两种不同形式的CASE语句。您可以这样简化它，因为您在每种情况下都比较相同的表达式：

CASE ReceivedMessages.IsComplaint
  WHEN 0  THEN 'Incomplete'
  WHEN 1  THEN 'Complete'
  WHEN -3 THEN 'Inappropriate' 
END from ReceivedMessages

另一种选择是：

CASE
  WHEN ReceivedMessages.IsComplaint=0  THEN 'Incomplete'
  WHEN ReceivedMessages.IsComplaint=1  THEN 'Complete'
  WHEN ReceivedMessages.IsComplaint=-3 THEN 'Inappropriate' 
END

赞(0）回复(0）举报 2022-10-03

6l7fqoea2#

错误在此行中

CASE ReceivedMessages.IsComplaint WHEN ReceivedMessages.IsComplaint=0

应该是这样的

CASE WHEN ReceivedMessages.IsComplaint=0 THEN 'Incomplete'
WHEN ReceivedMessages.IsComplaint=1 THEN 'Complete'
WHEN ReceivedMessages.IsComplaint=-3 THEN 'Inappropriate' END

赞(0）回复(0）举报 2022-10-03

我来回答

为什么我的Case语句在‘=’附近抛出错误、不正确的语法？

2条答案

相关问题

热门标签

最新问答