How to update multiple tables from XML data

Question

I have 6 tables in an SQL Server 2000 database. The XML contains a similar schema. What I want is to update the records in the database and append the new entries. I am a bit new to this.

Answer 1

You haven't specified the programming language you'll be using to update the database tables. If you intend to use T-SQL then have a look at OpenXml. This Link might be a starting point. You can use the result of the SELECT statement to perform an insert/update etc.