假设：表中有以下列列A varchar(50)列B varchar(50)合并显示为：select A+'-'+B as AB from 表若列的属性不一致需要转换一下：select cast(A as varchar(50))+'-'+cast(B as varchar(50)) as AB from 表
