SQL Server gives you option to retrieve data as XML by supporting For XML clause, which you can use as a part of your query. For XML clause supports different options that let you define the format of XML data.
For XML clause supports four modes- RAW, AUTO, EXPLICIT, PATH. When you include the FOR XML clause in your query, you must specify one of these four modes.
For XML clause supports four modes- RAW, AUTO, EXPLICIT, PATH. When you include the FOR XML clause in your query, you must specify one of these four modes.