Using the xml Data Type
The xml data type is a real problem solver for those who use both XML and SQL Server on a daily basis. Relational columns and XML data can be stored side by side in the same table, in an implementation that plays to the strengths of both. With SQL Server’s powerful XML storage, validation, querying, and indexing capabilities, it’s bound to cause quite a stir in the field of XML content management and beyond.
Some of the benefits of storing XML on the database tier can be realized immediately. Building middleware using the .NET Framework to manage XML stored in columns, rather than on the filesystem, is a far more robust solution than depending on the filesystem; plus, it’s a lot easier to access the content from anywhere. ...
Get Microsoft® SQL Server 2012 Unleashed now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
