has anyone done updates using openxml with an xml doc that is element based?
the examples only show how to do it with an attribute based document. can
the with option be used for this? any examples would be appreciated!
Steve
by Stev » Thu, 31 May 2001 01:14:39
Steve
by Bryant Like » Thu, 31 May 2001 02:17:58
See the BOL.Quote:> has anyone done updates using openxml with an xml doc that is element
based?
> the examples only show how to do it with an attribute based document. can
> the with option be used for this? any examples would be appreciated!
Look at the second example in section B.
--
Bryant
1. How to update the Xml elements using OPENXML ?
Hi,
I have a sql stored procedure with the xml data passed in form the dotnet
component.
I iterate through this xml using OPENXML and do the database updates etc. In
the meantime I have to update the elements in the XML being iterated and
send it back to the called component, so that the dotnet component recreates
the dataset using READXML method.
Can somebody direct me what to do here?. I just need a way to update the XML
in the stored procedure.
Thanks
Rajesh Karkera
2. Drawing lines, shapes etc on a picture box.
3. Problem when saving a large number of XML elements using insert with openxml
4. Stored Procedure Concurrency Problem
5. Help using OPENXML to retrieve specific elements for use in SQL insert (SQL*Server 2000)
7. Using OpenXML with both attributes and elements
8. ABF on VAX, VAX C still required?
9. OPENXML and element centric mapping
10. OPENXML path expression <root><element>VALUE
11. OpenXML question: Multiple occurence elements
12. OPENXML Bug: Maximum element nesting level of only 16
13. Adding BizTalk name space to element breaks OPENXML stored proecedure