Scenario
When a patient visits a hospital the doctor after diagnosing the patient's symptoms refer the patient to a specialist in another hospital or lab for test. On further investigation the specialist may remove a symptom if the test goes negative; hence those are removed from the PMD document.
Operation
XML data can also be modified using a stored procedure.
CREATE PROCEDURE
-- Creates procedure. It is permanently deployed to a database and can be call from an application.
It encapsulates the source code which actually does the operation. The code is stored as a compiled code with an execution plan..XMLTRANSFORM
-- Can be used to modify an XML document by inserting, replacing or deleting particular nodes.do delete
-- Deletes a node from a XML document.Solution
The symptoms which are no longer true for the patient is removed from the PMD document.