mardi 5 mai 2015

Select @xml.nodes ... how to assign column?

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:

--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

Aucun commentaire:

Enregistrer un commentaire