我可以使用SQL从XML查询/更新数据吗?

时间:2021-10-22 11:00:06

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 server, but can the xmls be updated using that?

我可以使用SQL从XML查询/更新数据吗?我有一些想法可以通过将xmls导出到sql server来完成,但是可以使用它来更新xmls吗?

Is there any other utility?

还有其他实用工具吗?

1 个解决方案

#1


1  

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.

updategram是一种可用于表示数据更改的数据结构。 INSERT,UPDATE和DELETE命令在updategram中通过之前数据的图像与更改后的数据的图像的差异来表示。

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.

运行XML updategram的一种方法是将updategram保存为文件,然后将URL中的文件作为模板文件运行。

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

您可以参考文档以便如何操作。

#1


1  

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.

updategram是一种可用于表示数据更改的数据结构。 INSERT,UPDATE和DELETE命令在updategram中通过之前数据的图像与更改后的数据的图像的差异来表示。

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.

运行XML updategram的一种方法是将updategram保存为文件,然后将URL中的文件作为模板文件运行。

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

您可以参考文档以便如何操作。