title: sql server xml delete two attributes at the same time
body: <p>I found the following which shows how to delete an attribute from XML in SQL Server: <a href="https://stackoverflow.com/questions/5345746/how-to-delete-an-attribute-from-an-xml-variable-in-sql-server-2008">How to delete an attribute from an XML variable in sql server 2008?</a></p>
  
  <p>But I would like to delete two attributes at once. I tried something like the following:</p>
  
  <pre><code>UPDATE TABLE SET
    xmlField.modify('delete  (/clue_personal_auto/@attr1)[1]'),
    xmlField.modify('delete  (/clue_personal_auto/@attr2)[1]')
   WHERE compare = 357
  </code></pre>
  
  <p>But I get an error that the same column cannot be modified more than once during an update. Is there a way to delete both within once statement, or should I just run two separate updates?</p>