检查SQL CASE语句中是否存在

SELECT * FROM table_name WHERE CASE_EXPRESSION;

SELECT * FROM employees WHERE CASE WHEN salary > 10000 THEN 1 ELSE 0 END = 1;

CREATE PROCEDURE check_case_expression
AS
BEGIN
    DECLARE @result INT;
    SELECT @result = CASE_EXPRESSION;
    IF @result = 1
        PRINT 'CASE expression exists';
    ELSE
        PRINT 'CASE expression does not exist';
END;

CREATE PROCEDURE check_case_expression
AS
BEGIN
    DECLARE @result INT;
    SELECT @result = CASE WHEN (SELECT COUNT(*) FROM employees WHERE salary > 10000) > 0 THEN 1 ELSE 0 END;
    IF @result = 1
        PRINT 'CASE expression exists';
    ELSE
        PRINT 'CASE expression does not exist';
END;