Question

SQL如果使用查询语句改变字段类型输出结果

如:select hight+name as 'detail' from a
假如hight字段类型为int,name为char,如何将int类型转为char类型，即要怎么修改select语句才能正确输出hight+name的结果。

Answer 1

SELECT CONVERT(VARCHAR(50),hight)+CONVERT(VARCHAR(50),name) AS 'detail' FROM a

Answer 2

select (char)hight as h,name as n from tablename

Answer 3

SELECT DIGITS(hight) + name as 'detail' from a

or
SELECT TO_CHAR(hight) || name as 'detail' from a