XML and T-SQL

SQL Server allows that storage of XML in table columns.

The XML can be stored in either a plain text data type or as valid XML.

The most efficient way of accessing the XML is using a temporary table to store XML data.

The main reason is that the column may not be an XML data type and it also allows more control over the output.

XML Text Values

The XML text is a value specified between the start and end tags.

USE DATABASE  
DECLARE @XmlTable TABLE (XmlResult XML)

INSERT INTO @XmlTable  
    SELECT
        [Book].[XmlBook]
    FROM [Book]