軟件測試開發技術SQL Server 2000數據庫FOR XML查詢概述

　　查詢語句：

　　SELECT 1 AS Tag,NULL AS Parent,

　　CategoryID AS [Category!1!ID],

　　CategoryName AS [Category!1!Name],

　　NULL AS [Product!2!ProductID!element],

　　NULL AS [Product!2!ProductName!element]

　　FROM Categories WHERE CategoryID < 3

　　UNION ALL

　　SELECT 2 AS Tag,1 AS Parent,

　　Categories.CategoryID AS [Category!1!ID],

　　Categories.CategoryName AS [Category!1!Name],--這里可以使用NULL代替

　　ProductID AS [Product!2!ProductID!element],

文章來源于領測軟件測試網 http://www.kjueaiud.com/