AnsweredAssumed Answered

Can pi/historian query the XML data type in SQL Server

Question asked by achalk on May 23, 2013
Latest reply on May 23, 2013 by mmueller

Newbie alert.


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?


Many thanks.