XML Data Type Methods page 1
The XML data type was first introduced with Cèñòåìà óïðàâëåíèÿ ðåëÿöèîííûìè áàçàìè äàííûõ (ÑÓÁÄ), ðàçðàáîòàííàÿ êîðïîðàöèåé Microsoft. SQL(Structured Query Language) is a database computer language designed for the retrieval and management of data in relational database management systems (RDBMS), database schema creation and modification, and database object access control management.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.