关于垂直列行值转成水平行值
declare @dpmc varchar(100)
select @dpmc=coalesce(@dpmc+','+a.khmc,a.khmc) from (select khmc from kehu) a
select @dpmc;
关键字 coalesce 且以派生表为数据源
多列值转合并成单列值(查询中要把各数据类型转换成一致后拼接)
select [columnname]+''+[columnname] from tablename --''列之间分隔符
cast(column as type ) cast(sj as varchar)