Top "For-xml-explicit" questions

In MS SQL Server, the EXPLICIT mode (of a FOR XML clause) provides the most flexibility in generating the XML you want from a query result.

SQL Server EXPLICIT mode with FOR XML

I am using SQL Server 2008 and I'm trying to produce a custom xml using EXPLICIT mode with FOR XML. I …

Read More
sql-server-2008 tsql for-xml for-xml-explicit
Suggestions on Troubleshooting "FOR XML EXPLICIT" Msg 6833 "requires parent tags to be opened first" Error

I have inherited a 1000-line stored procedure which produces XML by using FOR XML EXPLICIT. My problem is that it …

Read More
sql-server xml for-xml-explicit