Scripts for “SQL Tricks: Insights from Microsoft IT”

re: Scripts for “SQL Tricks: Insights from Microsoft IT”

Jude — Fri, 28 Nov 2008 17:00:00 GMT

Cool tricks!

And XML string concatenation trick!

I'm not too expirienced with SqlServer, but everyone knows this:

declare @a varchar(max)

select @a=isnull(@a+', '+parentstring,parentstring)

from

parent p join child c on p.parentid=c.parentid where c.childid=2

select @a

which yeilds the same results.

re: Scripts for “SQL Tricks: Insights from Microsoft IT”

Ward Pond — Mon, 01 Dec 2008 05:58:50 GMT

Hi Jude..

You're correct; the syntax you nominate would give the same result as the XML concatenation trick. However, your syntax is not ANSI standard, and is therefore not something that I'd encourage.

The XML concatenation trick is fully ANSI compliant, which is why I prefer it.

Thanks for your note!

-wp

http://code.msdn.microsoft.com/wardpondteched2008

TrackBack — Wed, 03 Dec 2008 23:36:51 GMT