Character limit on string variables?
Posted on 2006-10-27
I have code that produces a long xml string. My variable (which is called xml) is set like this...
I then go through the process of assigning the xml to it.
When complete I can view the length of the xml variable like this...
And it tells me it's a bit over 20 thousand characters.
That's all fine but when I try to actually view the xml string only an empty string is returned.
I have an sql server stored procedure that accepts xml as a parameter and i'm trying to parse this xml to the stored procedure. But I can't seem to do anything with it.