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 |
|
royalhale
Starting Member
1 Post |
 Posted - 2007-08-03 : 21:42:38
|
| We need to store large xml formatted strings in a text datatype field in the sql 2000 database. It is easy to process this xml data if passed to an application written in .Net but is there a way to pull the data in a stored procedure and then process it in the same procedure. I know you can't use the text data type as a local variable,which would be ideal since we could then use openxml, so I'm not sure if I could use OpenXML to query this data since I couldn't assign it to a text datatype variable to then sp_xml_preparedocument and process like I could if I passed it to the proc from .Net.The idea is to store the data at the time the student imputs the data and then later process this xml in a job storing the data in other tables for reporting.For performance reasons, processing the data at the time it is imput, won't work.We do need to keep the xml format in the table.ThanksRoyal |
|
|
|
|
|
Query xml data from text datatype row