I have table with column type as XML and XML that is stored has following structure
It is possible that XML that is stored can also be as below
I goal to write a query such that it will only the node i.e. result should like below
I have been trying query(), data() and value() function in the SQL query, but none seems to working
Does anyone have a suggestion on this?
One of methods that I am using (and is working) now is :SELECT CASE WHEN ResultXML.exist(‘(/Sites/SharePoint/CreateWeb)’)= 1
CREATE TABLE TestTable ([Xml] XML)
Thanks PolishChuck, This is exactly what I was looking for