What is typed XML? - Sql server 2005 XML

          

What is typed XML?

<<Previous   Next>>

What is typed XML? - March 09, 2009 at 11:00 AM by Amit Satpute

What is typed XML? 

  • Typed XML columns, parameters, and variables can store XML documents or content which need to be specified at the time of declaration with a flag whether you are storing a document or content.
  • A DOCUMENT should be specified if each XML instance has exactly one top-level element else CONTENT should be specified.

Situations to use Typed XML:

  • Typed XML data have schemas. The server validates the XML data according to the XML schemas.
  • Advantage of storage and query optimizations based on type information can be taken.
  • Advantage of type information during compilation of the queries can be taken. 

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