带有转换语句的SQL情况

Question

我需要选择一个将值转换为int并在另一列中设置一个数字的选择。

SELECT
    * ,
    (CASE WHEN City = 'London' THEN '2' ELSE '1' END) AS Status 
FROM
    customers

问题是我想在int中转换2：

SELECT
    * ,
    (CASE WHEN City = 'London' THEN CAST(City AS INT) '2' ELSE '1' END) AS Status 
FROM
    customers

看来它仅接受一个操作？

Answer 1

您可以尝试此

 SELECT  * ,
(CASE WHEN City = 'London' THEN CAST('2' AS INT) ELSE CAST('1' AS INT) END) AS Status 
FROM
customers

或

 SELECT  * ,
(CASE WHEN City = 'London' THEN 2 ELSE 1 END) AS Status 
FROM
customers

为了将城市名称转换为numeric，似乎不现实您永远无法将城市名称转换为任何世界上的整数。