XPath语法

清华大佬耗费三个月吐血整理的几百G的资源,免费分享!....>>>

SELECT ProductID AS '@ProductID',
ProductName AS 'ProductName'
FROM Products
FOR XML PATH ('Product'), ROOT ('Products')