SQL SERVER 利用CASE语句合并多行值！

declare @ManToRead as nvarchar(100)
select @ManToRead=case when ISNULL(@ManToRead,'')='' then '' else @ManToRead+'|' end +labor from view_labor where titlename like '%站点新增%'
select @ManToRead

 

类似这种的都可以达到效果！