Answer:
It is a system procedure which is used to read the XML document in the memory and returns a handle to this document. After that you can use OPEN_XML method to iterate through the xml result set.
Before OPEN_XML, one has to use sp_XML_Preparedocument.
Asked In: Many Interviews |
Alert Moderator