SQLTeam.com | Weblogs | Forums

XML to Table

sql2012

#1

Hi To All

i have a XML with Some Data , sql provide a functionality for create XMl from Table an we can read XML and get the data, but we have to pass the node and datatype of the node,
i have a XML which is coming from different sources and i dont know the Node and it's datatype , is it possible to create a function which is return a table base on passed XML