title: How to select all column in XML
body: <pre><code>DECLARE @x AS XML
  SET @x = '&lt;Table1&gt;&lt;c1&gt;&lt;![CDATA[1]]&gt;&lt;/c1&gt;&lt;c2&gt;&lt;![CDATA[Sample Record]]&gt;&lt;/c2&gt;&lt;c3&gt;&lt;![CDATA[Test Data]]&gt;&lt;/c3&gt;&lt;/Table1&gt;'
  SELECT * FROM @x.nodes('/Table1')
  </code></pre>
  
  <p>I want to select all columns without defining the column name (using *)</p>