title: Select @xml.nodes ... how to assign column?
body: <p>I want to put result of my xml.node sql into table and ran into this small problem like missing column name, can anybody recomend me.
  This will break single file xml into  nodes, one node per one row..
  this sample below works OK, but I need activate commented lines somehow:</p>
  
  <pre><code>--CREATE TABLE  TSxml  (TSNum INT IDENTITY (1,1),  xmlinfo XML)
  --SELECT * FROM TSxml
  declare @xml XML = (select c1 from t3)
  --INSERT INTO TSxml 
  --SELECT * FROM (
    SELECT T.N.query('.')
     FROM @xml.nodes('/testsuite') as T(N)
  --) AS C1
  </code></pre>