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

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 for “Sahil Malik explains tsql’s new feature "for xml".

  1. February 21, 2007 at 13:36

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

  2. February 21, 2007 at 16:23

    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)

  3. February 21, 2007 at 16:48

    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

  4. February 21, 2007 at 18:54

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

  5. February 21, 2007 at 19:09

    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 ๐Ÿ™‚

Comments are closed.