SQL Server Error Code – 1086 the for xml and for json clauses are inv

AbundantCode 1 week ago in SQL Server 0

In this blog post, you’ll learn more about the SQL Server Error Code 1086 and the error message description that is shown

SQL Server Error Code

1086

SQL Server Error Description for the Code :1086

The FOR XML and FOR JSON clauses are invalid in views, inline functions, derived tables, and subqueries when they contain a set operator. To work around, wrap the SELECT containing a set operator using derived table or common table expression or view and apply FOR XML or FOR JSON on top of it.

Tags :

Leave Your Comment