From: Mr. Magic on 31 Mar 2010 17:35
I have an XML field in a table and want to update values in the XML.
Can somebody point me to where updating a field in XML is actually
TIA - Jeff.
From: Michael Coles on 4 Apr 2010 00:05
"Mr. Magic" <Mufasa(a)NoWhere.Com> wrote in message
>I have an XML field in a table and want to update values in the XML.
> Can somebody point me to where updating a field in XML is actually
In what way are you trying to update it? I mean the standard UPDATE
statement does the trick pretty easily if your update is a wholesale
SET My_XML_Column = @My_XML_Variable;
If you're trying to update individual nodes within the XML stored in the
column without doing a wholesale replacement it gets a little more
complicated since you need to use XML DML, which requires knowledge of
XQuery paths. If that's the case then try Googling XML DML. If you can
share more specific information about your problem you'll probably get a
SQL Server MVP
Author, "Expert SQL Server 2008 Encryption"