XML in SQL Server

Everything about XML in SQL Server

1. Article · SQL

   Using For XML Clause In SQL Queries

   For XML clause is used to convert the SQL result set into XML format. It is a very much helpful clause when we need XML data from the SQL result set. The FOR XML clause can be used in top-level queries and in subqueries. The top-level FOR XML clause can be used only in the SELECT statement. In sub queries, FOR XML can be used in the INSERT, UPDATE, and DELETE statements. 

   Rohol AminMar 7, 202311,3211,000