|
|
RAW mode of FOR XML
|
RAW mode of FOR XML - March 16,
2009 at 16:45 PM by Amit Satpute
Explain the RAW mode of FOR XML with an example
-
Each row in the query result is transformed into an XML element that has the
generic identifier <ROW>
or the
optionally provided element name in RAW mode.
-
With ELEMENTS directive, each column value is mapped to a subelement of the
<row>
element.
- XMLDATA option, an in-line XDR schema is returned.
- XMLSCHEMA option returns an in-line XSD schema.
-
BINARY BASE64 returns the binary data in base64-encoded format.
|
|
|
|
|
