title: Xquery nodes value
body: <p>I need to get the value of AccountName in my table</p>
  
  <pre><code>&lt;rows&gt;
    &lt;Row xmlns="http://adcenter.microsoft.com/advertiser/reporting/v5/XMLSchema"&gt;
      &lt;AccountName value="MA_Yellowpages - AdStore" /&gt;
    &lt;/Row&gt;
  &lt;/rows&gt;
  </code></pre>
  
  <p>I am using below thing -</p>
  
  <pre><code>;WITH XMLNAMESPACES('http://adcenter.microsoft.com/advertiser/reporting/v5/XMLSchema' AS ns)
  select
  temp.query('AccountName[1]').value('@value','varchar(1000)') AS AC
  from  yp.dbo.Audit_ApiCallRawXml CROSS APPLY
        RawXML.nodes('/rows/ns:Row') lg(temp)
  </code></pre>