Hi,
I have an xml string which i do send it as a parameter for a sql stored procedure .
The issue i'm facing is , i need to send a double quote around a value .but when i send that
through xml/xsl it converts it into a double quote even before it reaches sql server and it gives an error
in the sql stored procedure since the input string is not a well formatted xml string .
here is an example .
This works if i run from sql server -query analyzer .
but when i try to send that " from xml/xsl it converts to double quote and gives error
in stored procedure .
Any help greatly appreciated .
Thanks
I have an xml string which i do send it as a parameter for a sql stored procedure .
The issue i'm facing is , i need to send a double quote around a value .but when i send that
through xml/xsl it converts it into a double quote even before it reaches sql server and it gives an error
in the sql stored procedure since the input string is not a well formatted xml string .
here is an example .
This works if i run from sql server -query analyzer .
Code:
exec de.sp_proc @xmltxt='<look><id="1" VAL=""yahoo""/></look>
in stored procedure .
Any help greatly appreciated .
Thanks