title: Update XML stored in a XML column in SQL Server
body: <p>I have a sample table in SQL Server 2012. I am running some queries against but the <code>.modify()</code> XQuery method is executing but not updating.</p>
  
  <p>Here is the table</p>
  
  <p><img src="https://i.stack.imgur.com/rVFBK.png" alt="Xml Table"></p>
  
  <p>For this just trying to update settings to 'NewTest'</p>
  
  <p><img src="https://i.stack.imgur.com/JtjZs.png" alt="Xml Snippet"></p>
  
  <p>This will execute but nothing is updating! Thanks for any help!</p>
  
  <p><img src="https://i.stack.imgur.com/1FeO0.png" alt="Not Update Snippet"></p>