I found a good example of OpenXML here:
I have a question and that is, with OpenXML, is there a way to modified the underlying xml document that gets feed into the OpenXML statement? I already know xQuery with Modify can modify the XML but was just wondering if there is an additional way of making the changes, like in the form of Update, Insert, Delete to a table. And I am not referring to making Update, Insert, or Delete to another database table but the OpenXML table itself.
So far, I gather that OpenXML is only for viewing (SELECT) the XML document.