title: How to decode XML entities in SQL?
body: <p>How can I convert/decode a text in <code>&amp;#1594;&amp;#1604;&amp;#1575;&amp;#1605;&amp;#1581;&amp;#1587;&amp;#1610;&amp;#1606;</code> format to normal text? I'm using SQL server 2012. I just want to update all of them to normal text.</p>
  
  <p><img src="https://i.stack.imgur.com/Rlp0y.jpg" alt="Table"></p>