Reference no: EM13891589

Create a table of XML documents with a type of XML. Use a primary key (you can't use an XML type) so add a field of type INT that is an identity.

Insert several records into the XML field in this new table. Use the following template:

<Root>
<ProductDescription ProductID=""ProductName="">
<Features>
<Warranty></Warranty>
<Maintenance></Maintenance>
</Features>
</ProductDescription>
</Root>

Once these have been added, modify the structure of XML inside of your XML typed field to add another tag of <Material></Material>

Within the Features tag, use the "modify" function to make this happen.

Once this is complete, write an XQuery query using the value clause to return a single record.

CREATE TABLE script, the INSERT statements, the "modify" script, and the XQuery script.