HF RL Explorer

Task: Avoid Character Encoding in SQL Server FOR XML PATH

Task: Avoid Character Encoding in SQL Server FOR XML PATH: a task in Terminal-Lego-15k (Harbor dataset). You need to create a SQL query that generates a comma-separated list of values from a SQL Server database table without XML character encoding. The challenge is that when using FOR XML PATH in…

The task

You need to create a SQL query that generates a comma-separated list of values from a SQL Server database table without XML character encoding. The challenge is that when using `FOR XML PATH` in SQL Server, special characters like `&`, `<`, and `>` are automatically XML-encoded (e.g., `&` becomes `&amp;`, `<` becomes…

Part of PrimeIntellect/Terminal-Lego-15k.