如何使用SQL Server 2005中的XML功能

1. FOR XML RAW

SQL语句：

   1:  SELECT EmployeeID,FirstName, LastName

   2:  FROM Employees

   3:  WHERE LastName LIKE 'D%'FOR XML RAW

所产生的XML文档如下：

   1:  <row EmployeeID="1" FirstName="Nancy" LastName="Davolio" />

   2:  <row EmployeeID="9" FirstName="Anne" LastName="Dodsworth" />

2. FOR XML AUTO

SQL语句：

   1:  SELECT EmployeeID,FirstName, LastName

   2:  FROM Employees

   3:  WHERE LastName LIKE 'D%'FOR XML AUTO

所产生的XML文档：

   1:  <Employees EmployeeID="1" FirstName="Nancy" LastName="Davolio" />

   2:  <Employees EmployeeID="9" FirstName="Anne" LastName="Dodsworth" />

3、关系数据表查询1：

   1:  SELECT Customers.CustomerID,CompanyName,OrderID,

   2:  CONVERT(VARCHAR(10), OrderDate, 101) AS OrderDate FROM dbo.Customers

   3:  INNER JOIN Orders ON Customers.CustomerID = Orders.CustomerID

   4:  ORDER BY Customers.CustomerID

   5:  FOR XML AUTO

生成XML文档结构：

4、关系数据表查询2：

SQL语句：

   1:  SELECT Customers.CustomerID,CompanyName,OrderID,

   2:  CONVERT(VARCHAR(10), OrderDate, 101) AS OrderDate FROM dbo.Customers

   3:  INNER JOIN Orders ON Customers.CustomerID = Orders.CustomerID

   4:  ORDER BY Customers.CustomerID

   5:  FOR XML AUTO, ELEMENTS

生成XML文档结果：

转载于:https://www.cnblogs.com/apiaceae/archive/2009/04/28/1445652.html