Can I use SQL to query/update data from XML?

Can I use SQL to query/update data from XML? I have some idea that it can be done by exporting the xmls to sql se开发者_JAVA技巧rver, but can the xmls be updated using that?

Is there any other utility?

An updategram is a data structure that you can use to express a change in the data. INSERT, UPDATE, and DELETE commands are represented in an updategram by the difference of the image of the data before and the image of the data after a change.

One way to run an XML updategram is to save the updategram as a file, and then run the file in the URL as a template file.

you can refer the document in order how to do it.