0

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?

Is there any other utility?

Improve this question
1
  • You can certainly import XML into SQL Server and "shred" them into relational data - but for the other way around, you really need a front-end, e.g. an application that grabs the data (as XML) from SQL Server and puts it into files. SQL Server isn't really designed to create new and update existing files - it's a database, after all - it handles data inside its storage Commented Sep 16, 2011 at 9:29

1 Answer 1

Reset to default
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.

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.

Improve this answer
Sign up to request clarification or add additional context in comments.

1 Comment

I don’t think this answers the question. The linked article is about how to express an SQL query in an “XML way”, not how to operate on XML data.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.