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];
 
SELECT
    XmlDom.Element.