SQL Server – Issues with generating XML using string operations

added by jacobsebastian
4/29/2010 11:29:22 PM

0 Kicks, 34 Views

The results of a SQL Server SELECT query can be transformed into an XML document by using the FOR XML command. Building XML documents using string functions – concatenating XML tags and embedding values between them using string operations – is not a recommended method. This post tries to look into some of the problems this approach can bring in.