mardi 5 mai 2015

Dynamic creation of fields from varying xml structure in sql server 2012

One of the columns in my log table is of type xml, the xml field stores parameters passed to different stored procedures executed in database. So each xml has got a different format and only the root node stays the same. I want to create a table to copy the data values in xml along with other fields in log table(basically expand each row). Any ideas on how to implement this in sql server 2012?

Aucun commentaire:

Enregistrer un commentaire