Generating self-closing xml tags for lists in SQL Server-CodePudding

Home > database > Generating self-closing xml tags for lists in SQL Server

Generating self-closing xml tags for lists in SQL Server

Time：08-19

I saw this xml example data in a 2013 SQL Server

Tags can be rendered in different ways depending on where and how the rendering is done. This can be in the query processor, specific FOR XML server-side code, or even by the client driver in some cases.

Details in What does server side FOR XML return? by the SQL Server Programmability Team.

Page link：https//www.codepudding.com/database/515412.html

Prev:How to write trigger to process batch update query with condition for each row that get update?

Next:Order of XML nodes from document preserved in insert?

Tags：

sql-server

tsql

sql-server-2019

for-xml

select-for-xml

Links：
CodePudding