XML is the standard format for exchanging data among different applications and platforms. It is widely used, and almost all modern technologies support it. Databases simply have to deal with XML. Although XML could be stored as simple text, plain text representation means having no knowledge of the structure built into an XML document. You could decompose the text, store it in multiple relational tables, and use relational technologies to manipulate the data. Relational structures are quite static and not so easy to change. Think of dynamic or volatile XML structures. Storing XML data in a native XML data type solves these problems,enabling functionality attached to the type that can accommodate support for a wide variety of XML technologies.

When to Use the XML Data Type

A database schema is sometimes volatile. Think about situations in which you have to support many different schemas for the ...
Read More

XML Data Type Methods

In the XQuery introduction in this chapter, you already saw the XML data type. XQuery was a parameter for the ...
Read More

Using the XML Data Type for Dynamic Schema

In this lesson, you learn how to use an XML data type inside your database through an example. This example ...
Read More

This lesson is a part of Querying and Managing XML Data from 70-461 Querying Microsoft SQL Server 2012 Prep course. More lessons in this chapter are

Returning Results As XML with FOR XML

XML is a widely used standard for data exchange, calling web services methods, configuration files, and more. This lesson starts ...
Read More

Querying XML Data with XQuery

XQuery is a standard language for browsing XML instances and returning XML. It is much richer than XPath expressions, an ...
Read More

Using the XML Data Type

XML is the standard format for exchanging data among different applications and platforms. It is widely used, and almost all ...
Read More

The Practice tests included in this course are:

Exam 70-461 Querying Microsoft SQL Server 2012 Practice Test 5

Instructions for Exam 70-461 Querying Microsoft SQL Server 2012 Practice Test 5 Number of Questions: The test has approximately 20-50 ...
Read More

Exam 70-461 Querying Microsoft SQL Server 2012 Practice Test 4

Instructions for Exam 70-461 Querying Microsoft SQL Server 2012 Practice Test 4 Number of Questions: The test has approximately 20-50 ...
Read More

Exam 70-461 Querying Microsoft SQL Server 2012 Practice Test 3

Instructions for Exam 70-461 Querying Microsoft SQL Server 2012 Practice Test 3 Number of Questions: The test has approximately 20-50 ...
Read More

Exam 70-461 Querying Microsoft SQL Server 2012 Practice Test 2

Instructions for Exam 70-461 Querying Microsoft SQL Server 2012 Practice Test 2 Number of Questions: The test has approximately 20-50 ...
Read More

Exam 70-461 Querying Microsoft SQL Server 2012 Practice Test 1

Instructions for Exam 70-461 Querying Microsoft SQL Server 2012 Practice Test 1 Number of Questions: The test has approximately 20-50 ...
Read More