代码之家 › 专栏 › 技术社区 › shami sheikh

“=”附近的语法不正确

stored-procedures tsql sql-server

shami sheikh · 技术社区 · 6 年前

我正在使用SQL Server存储过程,但SQL中出现语法错误 Case .

这是我的存储过程代码:

ALTER PROCEDURE [dbo].[spSelectServiceRequest]
AS
BEGIN
    SELECT 
        [id],
        [ServiceID],
        [fullName],
        [email], [mobile],
        [address],
        [serviceNeed],
        [problem],
        [serviceDate],
        [createdOn],
        [status] = CASE [status]
                      WHEN '1' THEN 'New Request'
                      WHEN '2' THEN 'Pending'
                      WHEN '3' THEN 'Accept By Provider'
                      ELSE 'Close'
                   END
    FROM 
        [tblBookingDetail]
    ORDER BY 
        [createdOn] DESC;
END;

任何帮助都将不胜感激。

3 回复 | 直到 6 年前

gotqn user3521065 6 年前

ALTER PROC [dbo].[spSelectServiceRequest]
AS
    BEGIN
        SELECT 
            [id]
          , [ServiceID]
          , [fullName]
          , [email]
          , [mobile]
          , [address]
          , [serviceNeed]
          , [problem]
          , [serviceDate]
          , [createdOn]
          ,  CASE [status]
                           WHEN '1'
                           THEN 'New Request'
                           WHEN '2'
                           THEN 'Pending'
                           WHEN '3'
                           THEN 'Accept By Provider'
                           ELSE 'Close'
                       END AS [status]
        FROM [tblBookingDetail]
        ORDER BY 
            [createdOn] DESC;
    END;

error_handler 6 年前

ALTER PROC [dbo].[spSelectServiceRequest]
AS
    BEGIN
        SELECT 
            [id]
          , [ServiceID]
          , [fullName]
          , [email]
          , [mobile]
          , [address]
          , [serviceNeed]
          , [problem]
          , [serviceDate]
          , [createdOn]
          , CASE [status]
                           WHEN '1'
                           THEN 'New Request'
                           WHEN '2'
                           THEN 'Pending'
                           WHEN '3'
                           THEN 'Accept By Provider'
                           ELSE 'Close'
                       END AS [Status]
        FROM [tblBookingDetail]
        ORDER BY 
            [createdOn] DESC;
    END;

AswinRajaram 6 年前

 ALTER PROC [dbo].[spSelectServiceRequest]
 AS
 BEGIN
    SELECT id
    ,ServiceID
    ,fullName
    ,email
    ,mobile
    ,address
    ,serviceNeed
    ,problem
    ,serviceDate
    ,createdOn
    ,CASE STATUS
        WHEN '1'
            THEN 'New Request'
        WHEN '2'
            THEN 'Pending'
        WHEN '3'
            THEN 'Accept By Provider'
        ELSE 'Close'
        END
     FROM tblBookingDetail
     ORDER BY createdOn DESC
 END