title: Deserialize XML data object in T-SQL
body: <blockquote>
    <p><strong>Possible Duplicate:</strong><br>
    <a href="https://stackoverflow.com/questions/13562635/deserialize-xml-object-in-t-sql">Deserialize XML object in T-SQL</a>  </p>
  </blockquote>
  
  
  
  <p>I got an XML object, and i want to deserialize him into a table using T-SQL.</p>
  
  <pre><code>&lt;Params&gt;
      &lt;paramtype type = '1'&gt;
          &lt;value&gt; abc&lt;/value&gt;
      &lt;/paramtype&gt;
  
      &lt;paramtype type = '2'&gt;
          &lt;value&gt; 123&lt;/value&gt;
      &lt;/paramtype&gt;
  &lt;/Params&gt;
  </code></pre>
  
  <p>How can i store all this data into a table like this: <br />
  <img src="https://i.stack.imgur.com/k4Jc8.jpg" alt="enter image description here"></p>