【数据库】SqlServer 类似 Mysql 的 group_concat 写法

sql server 2008没有group_contact功能

sql-server 2012之后微软提供了CONCAT函数可以实现这个功能

 

SELECT


    ( SELECT cDefine11 + ',' FROM RHM_V_CRM_RDRECORD32  WHERE cDefine12 = r.cDefine12 AND cdefine13 = r.cDefine13 FOR xml path('') )  AS cDefine11


FROM
    RHM_V_CRM_RDRECORD32 r 
WHERE
    r.cDefine12 = 'XX' 
    AND r.cdefine13 = 'XX'
    GROUP BY r.cDefine12, r.cdefine13