Posted by M A Srinivas on 04/04/07 11:38

On Mar 29, 4:05 pm, "AJA" <ajanospa...@gazeta.pl> wrote:
> > If you make an SP(stored Procedure) out of the Code , you can send
> > xml to SP as a text parameter
>
> Can you tell me clearly because i do not understand ..
>
> AJA

Need to do in an SP . You need to send text from client side. Sending
text within sql server not possible for SQL 2000

create proc usp_getxml
@xmltext TEXT
as
Declare @hdoc INT
--Create XML document.
EXEC sp_xml_preparedocument @hdoc OUTPUT, @xmltext

[Back to original message]