Changing multiple values in an XML column in SQL Server 2008
Posted
by Jeff B.
on Stack Overflow
See other posts from Stack Overflow
or by Jeff B.
Published on 2010-04-01T19:04:12Z
Indexed on
2010/04/01
19:13 UTC
Read the original article
Hit count: 252
I've got a column in a SQL Server table that is type XML. I want to change multiple values in the XML in a stored proc. I've already found the XML.Modify(...) command and have it working for a single value. Can I change multiple values in the XML in one update command or do I need to do it as multuple update commands?
© Stack Overflow or respective owner