SQL Server Getting error - Update where clause based on if -else condition

qojgxg4l 于 2023-10-15 发布在其他

关注(0)|答案(1)|浏览(98)

I have below query to select set of record based on the ccmflag condition.

CREATE OR ALTER PROCEDURE [dbo].[getdata]
    @p_ccmflag BIT = 0
AS
    SELECT *
    FROM dbo.data

    IF @p_ccmflag = 1
    BEGIN
        WHERE CCMFlag = 1
    END
    ELSE
    BEGIN
        WHERE CCMFlag != 1
    END
    ORDER BY 1 ASC;

I am getting this error:

Msg 156, Level 15, State 1
Incorrect syntax near the keyword 'where'.

sql-server

来源：https://stackoverflow.com/questions/77272671/getting-error-update-where-clause-based-on-if-else-condition

1条答案

按热度按时间

pw9qyyiw1#

Earlier someone posted an answer, I tried that query and its working fine for me.

Query as below:

SELECT *
    FROM dbo.data
    WHERE COALESCE(CCMFlag,0) = @p_ccmflag
    ORDER BY 1 ASC;

赞(0）回复(0）举报 2023-10-15

我来回答

SQL Server Getting error - Update where clause based on if -else condition

1条答案

相关问题

热门标签

最新问答