Update Multiple Values In Xml with .modify method

Question

I have looked over release documentation for the 2012 SP1 release of Sql Server

and reviewed this old post.

TSQL 2005, XML DML - Update Two Values at once?

I am wondering is it possible to update multiple values now, or do you still need multiple update statements for the .modify method.

Thanks!

I don't think there's been any significant improvements in capabilities for the .modify() XQuery method in more recent releases — marc_s
– marc_s, Commented May 13, 2013 at 20:51
marc_s, make your reply a answer. so I can give you the answer. — KeyboardFriendly
– KeyboardFriendly, Commented Jul 3, 2013 at 16:44

marc_s · Accepted Answer · 2013-07-03 16:49:19Z

1

I don't think there's been any significant improvements in capabilities for the .modify() XQuery method in more recent releases. So I'm afraid you still cannot update multiple values at once - you'll have to use multiple calls to .modify()

answered Jul 3, 2013 at 16:49

marc_s

760k186 gold badges1.4k silver badges1.5k bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Update Multiple Values In Xml with .modify method

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related