Hi,
Can I use DBType.XML in .net 2.0 to pass xml string to a stored procedure in sql server 2000 ?
It's just that I know sql 2000 does not have xml type. If this is true then how is it possible to pass very large xml string to a stored procedure parameter? Remember that the xml strings may be more than 10000 characters.
At present, using .net 2.0, I am passing xml string using DbType.AnsiString with length of 50,000 and the stored procedure parameters that accepts the xmlstring is of type text.
I tried using DbType.XML in .net 2.0 but noticed that sql 2000 does not accept it.
Do you also know the max length of AnsiString?
Your thoughts please?
Thanks you
Hi,
Is there a specific reason why you need to pass the xml as one big string? i.e. Are you just writing the xml data to be stored as an xml document as a whole or can you break it up into "chunks"?
Breaking it up would require more time for the multiple calls to the database, but would solve the problem of length of string size as even 2005 has a max length.
Chris
|||Hi,I do not wish to break the xml into smaller pieces.
Please note that my question is just to do with passing a large xmlstring.
If it is ok, please read my first post to see exactly what I am after.
Thanks for replying
No comments:
Post a Comment