The addition of PATH mode simplifies, and adds flexibility to, the process of specifying an explicit structure for your XML data.
The XSINIL and ABSENT modifiers for the ELEMENTS option provide fine-grained control over SQL NULL representation in your XML result.
The TYPE option for converting your result XML to the xml data type.
Support is included for nested FOR XML queries.
KeywordsPath Mode Uniform Resource Identifier Node Test XPath Query Auto Mode
Unable to display preview. Download preview PDF.