Is there a best way to store XML to database (SQL 2005 Express Edition)?
I'm doing a sample program about online bookmark, I have created two fields
UserID Uniqueidentifier
ContentOfBookmark I'm not sure what kind of field (ntext, XML or other field)
I plan to store the following XML content to the field ContentOfBookmark, first I set the ContentOfBookmark field as ntext type,
and restore the XML Content from the ContentOfBookmark field to a XML file, then use XMLReader to parse the XML file.
Now I heard there is a new XML field in SQL 2005 , but I don't know how to use it.
Do you think which kind of field I should use?
what I think about the bookmark is correct?
Is there a better way to resolve the hierarchical directory structure? If I store the structure in XML file, I think I can use many XML functions to operate bookmarks and folder easily such as add, delete bookmark; add delete folder...
========================== XML Content (ContentOfBookmark)============================================
======================= XML Content (ContentOfBookmark)===============================================
Replies
Know the answer? Post it — somebody with the same question will find it here.