[xquery-talk] SQL Server 2005
mrys at microsoft.com
Mon Jan 23 01:37:41 PST 2006
> Michael Rys wrote:
> > 1) I am not going to evangelize functionality that I do not
> > And it is not my problem if nobody writes about it...
> This is precisely the kind of steady business focus that has given
> Microsoft a black eye in the idealistic world of programmers. Shame,
> shame ;)
:-). LOL. Sorry about that then ;)
> > 3) As Kent says, you should use PATH mode in most cases.
> EXPLICIT mode
> > should only be used under the following circumstances:
> > 1. You already have it running...
> > 2. Sometimes it still executes faster than nested FOR XML
> PATH but not
> > always.
> > 3. You are a masochist...
> Looks like I need to take a closer look at FOR XML PATH...
Here is a whitepaper that shows what you can do with it and compares it
to the EXPLICIT mode:
> -- Ron
> talk at xquery.com
More information about the talk