Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
fmardani
Constraint Violating Yak Guru
433 Posts |
 Posted - 2007-02-23 : 16:46:18
|
| 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 |
|
|
Kristen
Test
22859 Posts |
Posted - 2007-02-24 : 05:00:27
|
| We used to use sp_xml_preparedocument to process large XML chunks (>1MB) and the performance was dreadful.So we switched to using the SQLXMLBulkLoad object instead.It is lightening fast by comparison - sp_xml_preparedocument took hours, SQLXMLBulkLoad takes seconds, literally!Kristen |
 |
|
|
|
|
|
pass large xmlstring to sql 2000 stored proc