XML Data Type Methods page 1
The XML data type was first introduced with SQL Server 2005.
This data type allows you to store XML data up to 2 GB.
There are five XML data type methods:
As an example we'll use database with XML data type fields.
Table tArtist contains information about music bands, singers and their albums.
Let's fill tables with sample data.