In SQL Server - FOR XML clause can be used within CTE . But it is stated in MSDN BOL as
The following clauses cannot be used in the CTE_query_definition:
To make it more clear , I raised a question on MSDN T-SQL forum - http://social.technet.microsoft.com/Forums/en-US/1b5d3c1a-0083-4f47-b6b0-35f86cdc2291/for-xml-clause-with-cte?forum=transactsql
Here is the Connect case [Feedback] for change in MSDN BOL documentation .
The following clauses cannot be used in the CTE_query_definition:
- ORDER BY (except when a TOP clause is specified)
- INTO
- OPTION clause with query hints
- FOR XML
- FOR BROWSE
To make it more clear , I raised a question on MSDN T-SQL forum - http://social.technet.microsoft.com/Forums/en-US/1b5d3c1a-0083-4f47-b6b0-35f86cdc2291/for-xml-clause-with-cte?forum=transactsql
Here is the Connect case [Feedback] for change in MSDN BOL documentation .
No comments:
Post a Comment