Example: Rename the <row> element
Applies to:
SQL Server
Azure SQL Database
Azure SQL Managed Instance
For each row in the result set, the RAW mode generates an element <row>
. You can optionally specify another name for this element by specifying an optional argument to the RAW mode, as shown in this query. The query returns a <ProductModel>
element for each row in the rowset.
Example
SELECT ProductModelID, Name
FROM Production.ProductModel
WHERE ProductModelID = 122
FOR XML RAW ('ProductModel'), ELEMENTS;
GO
This is the result. Because the ELEMENTS
directive is added in the query, the result is element-centric.
<ProductModel>
<ProductModelID>122</ProductModelID>
<Name>All-Purpose Bike Stand</Name>
</ProductModel>
See also
Pripomienky
https://aka.ms/ContentUserFeedback.
Pripravujeme: V priebehu roka 2024 postupne zrušíme službu Problémy v službe GitHub ako mechanizmus pripomienok týkajúcich sa obsahu a nahradíme ju novým systémom pripomienok. Ďalšie informácie nájdete na stránke:Odoslať a zobraziť pripomienky pre