I have a table that has XML data in a LONGTEXT column. I need to extract all
the data into a table. Can anyone give me some tips on the easiest way to do
this. The data is written to the table and will be extracted in real time.

Do you mean TEXT /NTEXT?

Are you using SQL Server 2000?

What is the nature of your extraction? Do you shred parts of the document
into relational fields? Do you need to preserve the full XML?

Thanks
Michael

"Mark D" <Mark D (AT) discussions (DOT) microsoft.com> wrote

SQL Server 2000, column is TEXT. Information is uploaded from a desktop and
manipulated on a web application. The vendor is storing the entire XML
document in this field. I need to extract each data element into a column in
another table to populate another application.

"Michael Rys [MSFT]" wrote: