开发者

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.

0

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜