Q&A for professionals and students of engineering
--SELECT QUOTENAME('abcdef') for xml path(''), type SELECT QUOTENAME('abcdef') for xml path('gozilla'), type SELECT ('abcdef') for xml path('gozilla'), type --declare @cols as nvarchar(max) --select @cols = STUFF((SELECT QUOTENAME('abcdef') for xml path(''), type).value('.','NVARCHAR(MAX)'),1,1,'') --print @cols;