如何使用SQL server中其他表中的列值插入xml顶级属性节点。

-- 步骤1：创建查询，检索需要的列值
SELECT c.CustomerID, o.OrderDate
FROM Customers c
JOIN Orders o ON c.CustomerID = o.CustomerID
WHERE c.CustomerID = '123'

-- 步骤2：使用FOR XML子句将查询结果转换为XML格式
SELECT c.CustomerID, o.OrderDate
FROM Customers c
JOIN Orders o ON c.CustomerID = o.CustomerID
WHERE c.CustomerID = '123'
FOR XML AUTO, ROOT('CustomerOrders')

-- 步骤3：使用XML方法和XQuery语法插入列值到XML的顶级属性节点
SELECT c.CustomerID, o.OrderDate
FROM Customers c
JOIN Orders o ON c.CustomerID = o.CustomerID
WHERE c.CustomerID = '123'
FOR XML AUTO, ROOT('CustomerOrders'), ELEMENTS XSINIL, TYPE