简化CTE字符串串联？

假设这是SQL Server，您是否考虑过以下内容：

select stuff((select ',' + c.pre + '-' + c.Meaning   from pres c   order by pre   for xml path ('')  ), 1, 1, '')

编辑：

要使用CTE进行此操作， 请先 定义顺序号，然后进行展平：

with c as (      select row_number() over (order by pre) as seqnum, c.pre + '-' + c.meaning as CodeMeaning      from pres c     ),     flattened as (      select CodeMeaning as CodeMeaning      from c      where rownum = 1      union all      select f.CodeMeaning + ',' + c.CodeMeaning      from c joinflattened fon c.seqnum = f.seqnum + 1     )select *from flattened;

如果列表太长，则可能必须增加默认递归级别。