Purpose of PATH mode of FOR XML in SQL Server 2005

          

Purpose of PATH mode of FOR XML

<<Previous   Next>>

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. 

<<Previous   Next>>
 



Write your comment - Share Knowledge and Experience


 

 
Latest placement tests
Latest links
 
Latest MCQs
» General awareness - Banking » ASP.NET » PL/SQL » Mechanical Engineering
» IAS Prelims GS » Java » Programming Language » Electrical Engineering
» English » C++ » Software Engineering » Electronic Engineering
» Quantitative Aptitude » Oracle » English » Finance
Home | About us | Sitemap | Contact us | We are hiring