SQL Server 2005

[Michael Rys]

> Michael Rys wrote:
> 
> > 1) I am not going to evangelize functionality that I do not 
> implement...
> > 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:

http://msdn.microsoft.com/library/en-us/dnsql90/html/forxml2k5.asp

> -- Ron
> 
> _______________________________________________
> http://xquery.com/mailman/listinfo/talk
> http://xquery.com/mailman/listinfo/talk
>