i'm trying to use openxml to insert xml data to a table. is it possible to load an xml file with sp_xml_preparedocument, i.e. specify a path and filename c:\tmp\new_xml.txt that contains xml data.
I too am having problems using OPENXML with a XML file. By replying to this, the thread will surface to the top again and perhaps someone who understands OPENXML will help the both of us.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.