SQL Server Error Msg 6826 – Every IDREFS or NMTOKENS column in a FOR XML EXPLICIT query must appear in a separate SELECT clause, and the instances must be ordered directly after the element to which they belong.

In this blog post, let’s learn about the error message “6826 – Every IDREFS or NMTOKENS column in a FOR XML EXPLICIT query must appear in a separate SELECT clause, and the instances must be ordered directly after the element to which they belong.” in Microsoft SQL Server, the reason why it appears and the solution to fix it.

SQL Server Error Message

6826 – Every IDREFS or NMTOKENS column in a FOR XML EXPLICIT query must appear in a separate SELECT clause, and the instances must be ordered directly after the element to which they belong.

Reason for the Error

To be update soon…

Solution

To be update soon…