EXPLICIT mode of FOR XML

          

EXPLICIT mode of FOR XML

<<Previous   Next>>

Explain the EXPLICIT mode of FOR XML with an example - March 16, 2009 at 16:45 PM by Amit Satpute

Explain the EXPLICIT mode of FOR XML with an example 

Using EXPLICIT Mode provides more control and flexibility in deciding the shape of the XML from a query result.

The EXPLICIT mode queries need to be written in a specific way so that the additional information about the required XML, such as expected nesting in the XML, is explicitly specified as part of the query.

Using PATH Mode with nesting is a simpler alternative to writing EXPLICIT mode queries.

It needs to be ensured that the generated XML is well formed and valid because the XML needed is described as part of the query in EXPLICIT mode 

<<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