CODEWITHSUNDEEP
sql-serverxmlsql-server-2008
Jeff B.
Jeff B.

Reputation: 11

Changing multiple values in an XML column in SQL Server 2008

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?

Upvotes: 1

Views: 416

Answers (1)

marc_s
marc_s

Reputation: 754538

You will need to use multiple (xmlcol).modify calls - you cannot update multiple bits at once, as far as I know.

Upvotes: 1

Related Questions