declare @x varchar(max) = ''
Select @x = @x + name + ', '  from sys.columns where object_id=3
select @x

SELECT Name + ', ' AS 'data()' FROM sys.columns where object_id = 3 FOR XML PATH('')

Select string_agg(name,', ')  from sys.columns where object_id=3