Hi there,
I am busy trying to read a table with millions of records which basically have a varchar(8000) field with XML-data into relational tables. I have studied XML with SQL Server, all kinds of tutorials, XMLSpy, XML View Mapper, SQLCML 3.0, you name it. I think I've got the basics down pat, know how to create an XDR or XSD schema, the works. I'm almost an XML expert ;-)
Now I wish to read those records and process the XMLdata in them. It seems I can only do this with the help of ADO of VB or C#, whatever. Is it not possible to process xml-data with T_SQL only? I've read up on OPENXML and SELECT FOR, but I doubt very much if this is the way to process the amount of data I have to go through.
Basically, can I process a batch with XML solely using T-SQL?
Any help apreciated.
Kind regards,
Hansje
I am busy trying to read a table with millions of records which basically have a varchar(8000) field with XML-data into relational tables. I have studied XML with SQL Server, all kinds of tutorials, XMLSpy, XML View Mapper, SQLCML 3.0, you name it. I think I've got the basics down pat, know how to create an XDR or XSD schema, the works. I'm almost an XML expert ;-)
Now I wish to read those records and process the XMLdata in them. It seems I can only do this with the help of ADO of VB or C#, whatever. Is it not possible to process xml-data with T_SQL only? I've read up on OPENXML and SELECT FOR, but I doubt very much if this is the way to process the amount of data I have to go through.
Basically, can I process a batch with XML solely using T-SQL?
Any help apreciated.
Kind regards,
Hansje
