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.

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 openxml limitation

Author  Topic 

fmardani
Constraint Violating Yak Guru

433 Posts

Posted - 2007-02-23 : 10:44:52
I am passing xmlstring as varchar(8000) to be used inside the openxml query.
At present I am using sql server 2000.
The issue is that some of the xmlstrings are longer than 8000 characters.
Tried using text but can not manipulate strings using text datatypes.

What is the alternative please?
   

- Advertisement -