Question

在线等：把两个字段合并成一个别名输出，帮我看一下这SQL语句怎么不对啊？

我想把msgvalue,msgfielddis 合并成一个别名输出：（就是输出组合成的一句话）
SELECT (msgvalue+msgfielddis) as A FROM ies_messagelayoutinfo
怎么差不出来啊

Answer 1

SELECT concat(msgvalue,msgfielddis) as A FROM ies_messagelayoutinfo ;

SELECT msgvalue||msgfielddis as A FROM ies_messagelayoutinfo

Answer 2

select CONVERT(varchar,msgvalue)+CONVERT(varchar,msgfielddis) as A from ies_messagelayoutinfo