选取的记录以逗号分开

[stevenjin]

SELECT DEPT FROM Info
DEPT拼接成：“技术部,采购部,市场部"

[吉普赛的歌]

USE tempdb
GO
IF OBJECT_ID('info') IS NOT NULL DROP TABLE info
GO
CREATE TABLE info(
	id INT PRIMARY KEY,
	dept NVARCHAR(20)
)
GO
SET NOCOUNT ON
INSERT INTO info VALUES (1,'技术部')
INSERT INTO info VALUES (2,'采购部')
INSERT INTO info VALUES (3,'市场部')

SELECT STUFF((SELECT ','+dept FROM info FOR XML PATH('')),1,1,'') AS result
/*
result
--------------------
技术部,采购部,市场部
*/

[Dear SQL(燊)]

USE tempdb
GO
IF OBJECT_ID('info') IS NOT NULL DROP TABLE info
GO
CREATE TABLE info(
    id INT PRIMARY KEY,
    dept NVARCHAR(20)
)
GO
SET NOCOUNT ON
INSERT INTO info VALUES (1,'技术部')
INSERT INTO info VALUES (2,'采购部')
INSERT INTO info VALUES (3,'市场部')

declare @dept nvarchar(4000)=''
select @dept=@dept+','+dept+''
from info

select right(@dept,len(@dept)-1)

------------------------------------------------------------------------------------------------------------
技术部,采购部,市场部