sql-server - SQL Server将结果选择为用 ','分隔的字符串

This question already has answers here:

How to concatenate text from multiple rows into a single text string in SQL server?

(48个答案)



Using COALESCE function to make values separated with commas

(5个答案)


7年前关闭。




我有一个返回一列的select查询，我想将其转换为以'，'分隔的字符串行

Select name
from tblUsers

给出结果:

Row1; asieh
Row2:amir
Row3:safoora

我想回来

Row1: asieh,amir,safoora

最佳答案

SQL Fiddle

MS SQL Server 2008架构设置:

CREATE TABLE tblUsers
    ([name] varchar(7))
;

INSERT INTO tblUsers
    ([name])
VALUES
    ('asieh'),
    ('amir'),
    ('safoora')
;

查询1 :

    SELECT STUFF((
        select ','+ name
        from tblUsers
        FOR XML PATH('')
        )
        ,1,1,'') AS names

Results :

|              NAMES |
|--------------------|
| asieh,amir,safoora |

关于sql-server - SQL Server将结果选择为用 ','分隔的字符串，我们在Stack Overflow上找到一个类似的问题：https://stackoverflow.com/questions/18702827/