I am designing a database to be implemented in MS SQL Server. I have the option of using the XML data type for certain data. I would want data stored in the XML data type to be queryable. if i wrote these queries myself they would use the XQuery functions of SQL Server.
Can pi/historian mine down into nodes of an XML file/fragment in an XML data type field in SQL Server?