sqlserver聚合字符串
原始: 想要结果:
create function joinFunction
(
@Id int
)
RETURNS varchar(1024)
AS
BEGIN
declare @Str varchar(1024)
set @Str = ''
select @Str = @Str + [Name] from AggregationTable
where [ID] = @Id
return @Str
END
GO
select ID,dbo.joinFunction(Id) as Name from AggregationTable
group by Id