title: How can I query a value in SQL Server XML column
body: <p>I have following XML stored in a XML column (called <code>Roles</code>) in a SQL Server database.</p>
  
  <pre><code>&lt;root&gt;
     &lt;role&gt;Alpha&lt;/role&gt;
     &lt;role&gt;Beta&lt;/role&gt;
     &lt;role&gt;Gamma&lt;/role&gt;
  &lt;/root&gt;
  </code></pre>
  
  <p>I'd like to list all rows that have a specific role in them. This role passed by parameter.</p>