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,674 reads

If you're an attendee at the PASS Data Community Summit this year, there are...

dead reckoning– v. intr. finding yourself bothered by somebody’s death more than you would...

Thank you for attending my PASS Summit 2025 session Answering the Auditor’s Call with...

Comments posted to this topic are about the item Personal Contact Is Vital

Comments posted to this topic are about the item Getting the Schema for Tables

Comments posted to this topic are about the item An Unexciting Exciting Release

What happens when I run this on SQL Server 2022 in the AdventureWorks2022 database?

SELECT OBJECT_DEFINITION (OBJECT_ID(N'Person.Person')) AS [Object Definition]; 
GO