O'Reilly logo

Programming Microsoft® ADO.NET 2.0 Core Reference, 2nd Edition by David Sceppa

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Using SQL Server 2005’s XML Features

All databases support XML, sort of. You can generally store XML data in a text-based field, but that’s nominal support at best.

SQL Server 2005 provides rich server-side XML features and we’ll cover these features in the "SQL Server 2005’s XML Type" section later in the chapter. But first, let’s briefly review the XML features available in SQL Server 2000.

SQL Server 2000 added the ability to take data stored in typical relational columns and return the data as a stream of XML through SELECT ... FOR XML queries. However, SQL Server 2000 did not provide truly rich server-side XML features. For example, there was no way to say that a column had to contain XML, let alone XML that conformed to a particular schema. ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required