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

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

Mladen — Sat, 15 Mar 2008 18:06:55 GMT

and don't forget the ampersand (&) character :)

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

Ward Pond — Sat, 15 Mar 2008 19:38:12 GMT

Just another nested REPLACE, Mladen.. we were just proving concept here. :-) If I can get Tony Rogerson's syntax working with this construction, we hopefully won't have to instantiate every entitizable character.

Stay tuned.. :-)

Database Programming: The String Concatenation XML Trick, Sans Entitization

Ward Pond's SQL Server blog — Wed, 19 Mar 2008 03:20:08 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:27 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:06 GMT

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

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

RBarryYoung — Mon, 23 Feb 2009 20:44:15 GMT

The solution that I have been using is:

--=====

--Transformed FOR XML String Concatenation:

select (

SELECT n + ','

FROM (

SELECT 'a<b' AS n

UNION ALL

SELECT 'b>a'

UNION ALL

SELECT 'b&a'

UNION ALL

SELECT 'b

a') r

FOR XML PATH(''), TYPE

).value('.[1]','varchar(max)')

-- =====

Which seems to me to be both faster and more complete.

Database Programming: The String Concatenation XML Trick, Revisited

Ward Pond's SQL Server blog — Fri, 27 Feb 2009 06:31:12 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:25:02 GMT

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