Discuss the below:
Q: 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:
Once these have been added, modify the structure of XML inside of your XML typed field to add another tag of
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.