we’ve developed an application that uses a database with a XML data type column. It works fine with SQLSERVER 2005 an above, but we cannot create the structure in SQLSERVER 2000 because it doesn’t support that data type.
We’ve made some test with SQLXML 3.0 packet and SQLSERVER 2000 but it only adds pseudo-support to work with XML documents. We need to store XML documents into a column and then make selects using XPath sentences over that column. For instance:
select * from users
where description.exist('//info[@value = "francesc"]') = 1
Is there any way to achieve this using SQLSERVER 2000??
Thanks in advance!
View Complete Post