Database Programming: The String Concatenation XML Trick

re: Database Programming: The String Concatenation XML Trick

Adam Machanic — Fri, 14 Mar 2008 23:28:19 GMT

This is a great technique, but there is a bit of a gotcha if you have any "special" characters in your strings (they can be "entitized" due to the fact that the FOR XML option is designed to produce XML) -- more info here:

http://sqlblogcasts.com/blogs/tonyrogerson/archive/2006/07/06/871.aspx

Database Programming: The String Concatenation XML Trick Revisited (Or, Adam Is Right, But We Can Fix It)

Ward Pond's SQL Server blog — Sat, 15 Mar 2008 12:22:09 GMT

A find shared by one friend leads to correspondence from another.. The redoubtable Adam Machanic left

Database Programming: The String Concatenation XML Trick, Sans Entitization

Ward Pond's SQL Server blog — Wed, 19 Mar 2008 03:20:09 GMT

When last we checked in on The Technique That Lance Found , Adam had noted that the method entitizes

Database Programming: The String Concatenation XML Trick, Finalized

Ward Pond's SQL Server blog — Fri, 21 Mar 2008 17:15:24 GMT

It's an especially Good Friday when we can close the loop on a technical conversation, and I believe

May Glad Tidings be Upon You

Ward Pond's SQL Server blog — Sat, 20 Dec 2008 18:55:03 GMT

UPDATED 20 Dec 2008 to fix links It’s that time of year again, when I disappear from the blogosphere

Database Programming: The String Concatenation XML Trick, Revisited

Ward Pond's SQL Server blog — Fri, 27 Feb 2009 06:31:07 GMT

I’ve got to pay more punctual attention to my comment pool.. RBarryYoung’s movingsql.com will be on my

T-SQL Challenge: Grouped String Concatenation

Adam Machanic — Fri, 27 Feb 2009 21:24:57 GMT

It's been quite a while since the LIKE vs ? Puzzle , and I feel like it's time for another one. Response

re: Database Programming: The String Concatenation XML Trick

Fri, 08 May 2009 15:42:50 GMT

Thanks very much. That did solve my problem.