Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 sp_xml_preparedocument & OPENXML

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2001-08-09 : 09:22:27
Neil writes "I would like to use these functions but I do not know how to pick up an xml file from the operating system. The help text in topic "Using OPENXML" is quite helpful but it does not show how to access an XML file that is resident on the operating system. The example types the text into the sql script.

Can you please let me know how to open an xml file and get it into the @doc variable.

Thank you."
   

- Advertisement -