替换select T-SQL后的输出值

SELECT CASE status
           WHEN 1 THEN '启用'
           WHEN 0 THEN '禁用'
           ELSE '未知状态'
       END AS status_text
FROM your_table;

SELECT ISNULL(column_name, '默认值') AS replaced_value
FROM your_table;

CREATE FUNCTION replace_value (@value INT)
RETURNS VARCHAR(10)
AS
BEGIN
    DECLARE @result VARCHAR(10);
    
    IF @value = 1
        SET @result = '替换值1';
    ELSE IF @value = 2
        SET @result = '替换值2';
    ELSE
        SET @result = '其他值';
    
    RETURN @result;
END;

SELECT dbo.replace_value(column_name) AS replaced_value
FROM your_table;