August 29, 2008 at 6:48 am
Hi,
In one of the previous written sp in my projects sp_xml_preparedocument (Transact-SQL)
is used ?
So what's the use of it ????
Please reply
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
August 29, 2008 at 8:09 am
Try using a search engine or BOL. There are many hits for this sp.
August 31, 2008 at 12:00 am
Thanks for ur response..but i need someone who can put light on it with his views.....
I have read thta BOL but i couldnt get it:)
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
August 31, 2008 at 9:00 am
that proc basically creates an instance of the DOM on the server. this is a COM object that implements an xml document parser. It's used when you use OPENXML queries.
when you are done with it you should call sp_xml_removedocument to free up the resources related to the DOM.
---------------------------------------
elsasoft.org
August 31, 2008 at 9:20 pm
Can't we use OPENXML queries without using it ??
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
August 31, 2008 at 10:03 pm
I don't believe so. one of the parameters you use in an OPENXML call is the document handle returned by that proc, so you pretty much need to call it if you are using OPENXML.
---------------------------------------
elsasoft.org
September 2, 2008 at 2:38 am
No you cannot
bhuvnesh.dogra (8/31/2008)
Can't we use OPENXML queries without using it ??
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply