Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Updating DB using OPENXML Expand / Collapse
Author
Message
Posted Monday, December 01, 2008 11:30 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

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

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?

regards
Pooja
Post #611832
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse