Koen Verbeeck (8/1/2012)
This question could have been so much more than just a simple trick question. Instead of focusing on attribute or element centric mapping (which you did a bit with the answers and by specifying a non-existant bit flag), you made the question a whole lot less interesting.The explanation doesn't even mention the different mappings and how they affect results.
+1
Hard to believe that the OPENXML is still so prevalently used, what with the addition of the XML data type (and the related xQuery and xPath functions) in SQL2005.
____________________________________________
Space, the final frontier? not any more...
All limits henceforth are self-imposed.
“libera tute vulgaris ex”