October 24, 2005 at 4:04 am
hi
im new in using xml and im trying to read an xml file.
im using the sp_xml_preperedocument procedure
the thing is the procedure takes a xml string
where as i have a xml file.
Is there a procedure/function that gets a xml file and outputs a xml string ???
or Is there a better way to import xml files into the sql server 2000 ???
October 24, 2005 at 6:58 am
See this
http://www.perfectxml.com/articles/xml/importxmlsql.asp
it has some code to get the file into a string for sp_xml_preparedocument providing you have permission to use xp_cmdshell
Far away is close at hand in the images of elsewhere.
Anon.
October 27, 2005 at 12:05 am
thx 🙂
its exactly what i was looking for
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply