如何在sql serevr中用逗号分隔的单列连接多行。 [英] how to concatinate multiple rows with comma separated single column in sql serevr.
本文介绍了如何在sql serevr中用逗号分隔的单列连接多行。的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
如何在sql serevr中用逗号分隔的单列连接多行。
解决方案
阅读:使用SQL Server 2008将多行连接成单个文本字符串 [ ^ ]
试试这个,
SELECT DISTINCT id,STUFF(( SELECT ' ,' + CONVERT ( VARCHAR ( 30 ),Column2)
FROM table1 AS S2
WHERE S1.id = S2.id
FOR XML PATH(' ')), 1 , 1 ,' ') AS Column_HoldingCommavalues
FROM table1 AS S1
how to concatinate multiple rows with comma separated single column in sql serevr.
解决方案
Read this : Concatenate many rows into a single text string using SQL Server 2008[^]
Try this, SELECT DISTINCT id, STUFF((SELECT ','+ CONVERT(VARCHAR(30), Column2) FROM table1 AS S2 WHERE S1.id = S2.id FOR XML PATH('')), 1, 1, '') AS Column_HoldingCommavalues FROM table1 AS S1
这篇关于如何在sql serevr中用逗号分隔的单列连接多行。的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文