Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in
Home       Members    Calendar    Who's On

Add to briefcase

Updating DB using OPENXML Expand / Collapse
Posted Monday, December 1, 2008 11:30 PM


Group: General Forum Members
Last Login: Wednesday, July 22, 2009 8:17 AM
Points: 10, Visits: 25

I have an XML message which is first read and inserted into a table using OPENXML. The next time the message comes it will contain only the modified values. In that case I should update only those columns which have been modified and the remaining column values should remain unchanged. How can I do this? I can read all the nodes in the XML using OPENXML excluding the WITH clause. But after that how can I selectively update the columns corresponding to the nodes retrieved?

Post #611832
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse