Diogo Castro

Representing XML data in SQL Server

In this article, we will see how to use the FOR XML statement in SQL Server to represent the result of queries in XML format.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

(21)

You rated this post out of 5. Change rating

2020-04-24 (first published: 2018-08-07)

6,689 reads

I had a customer ask about analyzing their Test Data Manager (TDM) usage to...

I had an idea for an animated view of a sales tool, and started...

Next Monday, February 9, 2026, my one-day live online training SQL Server Query Tuning...

Comments posted to this topic are about the item SQL Server 2025 Query Performance...

This is a generic question. To the moderators, I wasn't sure where to place...

Good Afternoon, I have built a table with four columns: Period(Month), Category, Numerator, Denominator....

On SQL Server 2025, what happens when I run this code:

SELECT JSON_OBJECTAGG( 'City':'Denver')
GO