Menu
Can you please help me will FOR XML PATH works in Azure Synapse. If not what will be the alternative.
Thanks
368
asked Oct 19 '25 03:10
In case you you're looking to use FOR XML to prepare e.g. column names for a dynamic pivot query, then the string_agg function is what you are looking for.
string_agg documentation
51
answered Oct 22 '25 08:10
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With