XML XQuery has the ability to modify an XML instance for the XML variable and XML columns. The XQuery modify() method provides the ability to add, delete, and update the XML elements, attributes, and their values. This chapter will discuss and demonstrate real case scenarios to apply the modify() method for XML instances.
5-1. Inserting a Child Element into Your XML
You want to insert a child element into an existing XML instance.
You may encounter a situation in which you need to insert an XML element into an existing XML instance. Consider the simple XML data ...