Peter E. Kierstead (12/16/2009)
Dude, you rock! I totally missed that in BOL... But I'm still not going to take back the MICROSOFT @)(@#$)(*@#$#@$...
Thank you.
As for the comment about MS: Trust me, the XML-in-SQL documentation is horrible. The more you use it, the more you'll hate the documentation. The functionality rocks, the documentation is miserable. So, expect to feel that way quite often if you go down that road.
And some of the functionality is quirky to the point of being neurotic. Like not being able to use For XML in an Insert Select, but being able to bypass that with a simple subquery. Why can't the parser and compiler just do the intuitive thing and turn it into a subquery behind the scenes for you? T-SQL is designed to do exactly that with so many things. But not this one.
It gets weird. Lets you do some pretty cool stuff, but definitely gets weird at times.
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon