Originally posted by: rm
There is xml data type in sql2k5, may try text type in sql2k.
Some articles mentioned BLOB is ideal for XML.
Currently, I want to store it in BLOB in SQL2000. But we may move to SQL2005 very soon.
For xml, do you think the data type of XML in SQL2005 is better than BLOB in SQL2000/2005?