Good Article Vasant, wrote in a very simple and easy way.

I have one doubt here about  sp_xml_preparedocument.

In BOL and also in the mentioned article XML document/content is assigning to a varchar variable and using in sp_xml_preparedocument. Instead of using the variable, can we also use a path where the XML file exists. If so how do we need to mention.

Can any one help regarding this with a simple syntax?

Thanks,

Subhash