title: Deserialize XML object in T-SQL
body: <p>I've got an XML object. And I want to deserialize it into a table using T-SQL. <br /> </p>
  
  <pre class="lang-xml prettyprint-override"><code>&lt;Params&gt;
      &lt;type = 1&gt; 
          &lt;value&gt; 10 &lt;/value&gt;
      &lt;/type&gt;
  
      &lt;type = 2&gt; 
          &lt;value&gt; abc &lt;/value&gt;
      &lt;/type&gt;
  &lt;/Params&gt;
  </code></pre>
  
  <p>How can I store this data into a table like this: <br />
  <img src="https://i.stack.imgur.com/GMAn2.jpg" alt="enter image description here"></p>
  
  <p>Thanks!</p>