May 17, 2002 at 8:21 am
If all I have for the xml text input param is an XML file name how can I use this sp to get the handle?
May 17, 2002 at 9:37 am
Use bulk copy to move the file into a temp table.
Select xml from the table into a variable then use sp_xml_preparedcoument to get the handle.
quote:
If all I have for the xml text input param is an XML file name how can I use this sp to get the handle?
May 20, 2002 at 7:04 am
Thanks for the help. I made a one column (text) table to hold the xml. The reason I chose text is because I fear I would quickly overrun the 8000 char/varchar limitation. Problem now is, since I can't build a text variable nor convert a pointer within the sp, I'm not sure how to proceed. Perhaps I can loop and pick up 8000 character blocks and pass them as a concatenated expression in the sp? Whaddya think?
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply