MSSQL Query

MSSQL and TSQL Programming and TSQL Examples

For XML Path in SQL Server

by · Published · Updated

Hello everyone,

In this article, I will talk about the use of For XML Path in SQL Server.

In SQL Server, the For XML Path statement is an expression used to output XML. It is a structure similar to the use of For XML Explicit. It is easier to use. The hierarchy structure is created automatically. Let’s examine the example usage using the Northwind database.

SELECT *
FROM dbo.Categories
FOR XML PATH;

When you run the above query, you will see a result similar to the one below.

For XML Path in SQL Server

Good luck to everyone in business and life.

90 Views

Tags:

Yavuz Selim Kart

I try to explain what I know in software and database. I am still improving myself by doing research on many programming languages. Apart from these, I am also interested in Graphic Design and Wordpress. I also have knowledge about SEO and Social media management. In short, I am a determined person who likes to work hard.

You may also like...

Don`t copy text!