Brian H. Madsen
Computer says no

Sahil Malik explains tsql’s new feature "for xml".

February 21st 2007 in 2103

After having read through Rob’s post about “scripting objects” and commented on it I saw that Sahil Malik had written a great post about the “For XML” feature of SQL Server’s TSQL!

He questioned why so few actually used it, when it obviously (according to Sahil that is) is a very powerful feature.

I fully believe it’s simply because very few are actually aware of its existence – which is odd because it’s published all over the place – but hey, horses for courses i say.

Anyways, good work Sahil on putting the techie blabber into conversational english for those that are eloquently challenged (eg. he has simplified the explanation somewhat).


5 comments to...
“Sahil Malik explains tsql’s new feature "for xml".”

Sahil Malik

LOL, hey man – are you calling my readers eloquently challenged?



robfarley

But the key thing here is that when you don’t use a column name, and you use FOR XML PATH (”), you get a concatenated string (and no angle brackets)



BrianMadsen

Hey Sahil – well i wouldn’t do that except i happen to know that Bill Ryan and myself are reading your blog regularly ;) he hehe



Sahil Malik

LOL, Brian – y’know what, I would love to go party downtown once with both of you together.



BrianMadsen

he hehehe…you’re a strange man Sahil – not many would actually volenteer for that type of socialising…something tells me that Bill’s a bit of a nutter :) me on the other hand, am completely harmless :)




required



required - won't be displayed


Your Comment:

*

Well, i’m definitely not the only one that gets bitten by the spam-phreaks. Michael seems to have finally gotten a taste of it and did, what everybody should do and killed it. no questions asked. I could almost understand if somebody tried to get just 1 or 2 comments in on a blog, this would […]

Previous Entry

It’s here – Reflector 5.0 has been released and i’m sure a lot of people has been waiting patiently for it. On Lutz Roeder’s site you can find links to Reflector and the different add-ins that’s available. I’m not entirely sure but i don’t think there’s anything that matches up to Reflector in doing what […]

Next Entry

  • An error has occurred, which probably means the feed is down. Try again later.