SQLServer:如何将固定值绑定到列？

SELECT
    column1,
    column2,
    CASE
        WHEN condition THEN '固定值1'
        ELSE '固定值2'
    END AS fixed_value
FROM
    table_name;

SELECT
    column1,
    column2,
    IIF(condition, '固定值1', '固定值2') AS fixed_value
FROM
    table_name;

SELECT
    column1,
    column2,
    CHOOSE(condition, '固定值1', '固定值2') AS fixed_value
FROM
    table_name;