问Server如何在select语句中重命名列？

EN

SELECT 
    CONTACTPHONE1 AS CONTACTPHONE1Orin,
    CONTACTPHONE2 AS CONTACTPHONE2Orin,
    REPLACE(TRANSLATE(UPPER(CONTACTPHONE1), '()-.,/+', '       '), ' ', '') AS CONTACTPHONE1,
    REPLACE(TRANSLATE(UPPER(CONTACTPHONE2), '()-.,/+', '       '), ' ', '') AS CONTACTPHONE2
INTO 
    [dbo].[gz_temp] 
FROM 
    Auct_ABSENTEEBID

SELECT 
    CONTACTPHONE1Orin,
    CONTACTPHONE2Orin,
    CASE
        WHEN ISNUMERIC(RIGHT(CONTACTPHONE1, 1)) = 0 
            THEN SUBSTRING([CONTACTPHONE1], 1 , LEN([CONTACTPHONE1]) - PATINDEX('%[0-9]%', REVERSE([CONTACTPHONE1]))) 
            ELSE CONTACTPHONE1
        END AS CONTACTPHONE1,
    CASE
        WHEN ISNUMERIC(RIGHT(CONTACTPHONE2, 1)) = 0 
            THEN SUBSTRING([CONTACTPHONE2], 1 , LEN([CONTACTPHONE2]) - PATINDEX('%[0-9]%', REVERSE([CONTACTPHONE2]))) 
            ELSE CONTACTPHONE2
        END AS CONTACTPHONE2
INTO 
    [dbo].[Auct_ABSENTEEBID_Phone_Cleaning]
FROM 
    [dbo].[gz_temp]

SELECT @@Version

Microsoft Azure SQL Data Warehouse - 10.0.15669.0 Jul 14 2022 22:09:30 Copyright (c) Microsoft Corporation