Explain the purpose of PATH mode of FOR XML in
SQL Server 2005 with an example - March 04, 2009 at 18:00 PM by
Amit Satpute
Explain the purpose of PATH mode of FOR XML in SQL Server
2005 with an example
The PATH mode provides a simpler way to:
-
mix elements and attributes,
-
introduce additional nesting for representing complex properties.
-
provide a simpler alternative to the potentially cumbersome EXPLICIT mode
queries.
PATH mode allows you to write queries with less complexity.
In PATH mode, column names or column aliases are treated as XPath expressions.
|