I have the following query for the Oracle database:
select xmlagg(xmlelement(e, d.delinha, '').extract('//text()') order by d.nulinha).getclobval()
.
I need to convert to run on SQLServer database, but I can not. Does anyone know of a function equivalent to SQLServer or another alternative to get the same result.