Storing XML in SQL Server 2005
I have generated an xml using C# for my current project and I want to save this xml in m开发者_如何学编程y database (SQL Server 2005).
If I save the XmlDocument
as datatype xml
in SQL Server 2005, will it degrade performance??? Which is the good method to save the xml?
http://msdn.microsoft.com/en-us/library/ms345118(v=sql.90).aspx
For perfomance related info read the section on XML indexes. As a general rule I would say it is a good idea to use the datatype designed to hold the type of data you want to store unless you can find a specific reason in your particular case that would make some other type a better choice.
精彩评论