What is sp_XML_Preparedocument procedure?

 Posted by Virendradugar on 12/5/2009 | Category: Sql Server Interview questions | Views: 10491
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 

Comments or Responses

Login to post response