FOR XML examples

The following examples show how the FOR XML clause can be used in a SELECT statement.

The following example shows how the FOR XML clause can be used in a subquery:

SELECT XMLELEMENT(
   NAME root,
      (SELECT * FROM Employees
       FOR XML RAW));

The following example shows how the FOR XML clause can be used in a query with a GROUP BY clause and aggregate function:

SELECT Name, AVG(UnitPrice) AS Price
FROM Products
GROUP BY Name
FOR XML RAW;

The following example shows how the FOR XML clause can be used in a view definition:

CREATE VIEW EmployeesDepartments
AS SELECT Surname, GivenName, DepartmentName
FROM Employees JOIN Departments
ON Employees.DepartmentID = Departments.DepartmentID
FOR XML AUTO;

Discuss this page in DocCommentXchange.