For xml explicit mode FOR further application

In the previous article, we briefly explained the most basic application of various fox xml modes. Now we need to describe more about the EXPLICIT it mode in the fourth mode: Suppose we want to generate the following XML document:

<Employee empid="1">

<Name>

<FName>Nancy</FName>

<LName>Davolio</LName>

</Name>

</Employee>

SQL statement:

-- Define the data structure of the output XML document

SELECT  1 AS Tag,

        NULL AS Parent,

        EmployeeID AS [employee!1!empid],

        FirstName AS [Name!2!FName!element],

        LastName AS [Name!2!LName!element]

FROM    Employees

UNION ALL

-- Input actual data

SELECT  2 AS Tag,

        1 AS Parent,

        EmployeeID,

        FirstName,

        LastName

FROM    Employees

ORDER BY [Employee!1!empid],

        [Name!2!FName!element],

        [Name!2!LName!element]

FOR     XML EXPLICIT

Tag value 2 indicates FirstName, and the parent element of LastName is Name