string_agg for sql server pre 2017
In SQL Server pre-2017, you can do:
select stuff( (select ',' + cast(t.id as varchar(max))
from tabel t
for xml path ('')
), 1, 1, ''
);
The only purpose of stuff()
is to remove the initial comma. The work is being done by for xml path
.