sql 多行并一起

2013-01-19

sql 多行并一行1)select _size from clothes where measurementNoM11-031-M1 for xml path()2)select

sql 多行并一行
1)

select _size from clothes where measurementNo='M11-031-M1' for xml path('')

select ','+_size from clothes where measurementNo='M11-031-M1' for xml path('')

3)去掉逗号

select  stuff((select ','+_size from clothes where measurementNo='M11-031-M1' for xml path('')),1,1,'')

SELECT measurementNo,       sizes= stuff(       (SELECT '/'+_size        FROM clothes c1 //c1不能少         WHERE  measurementNo=c2.measurementNo          FOR xml path('')       ),1,1,'')FROM   clothes c2group by measurementNo

参考：http://blog.csdn.net/dobear_0922/article/details/2313839