MSSQL 实现 group_concat

MSSQL 实现 group_concat

1.

DECLARE @s VARCHAR(max)
SET @s=''
SELECT @s=@s+','+sName FROM dbo.tUser

SELECTstuff( @s,1,1,'')

 

2.select STUFF
        (
            (
             SELECT CAST(',' AS VARCHAR(MAX))+sName            FROM dbo.tUser                                           
             
             FOR XML PATH('')
            )
            ,1
            ,1
            ,''
        ) AS sName