XML Data Type method layout SQL support
Can not use SQL prompt to layout XML data type functions, for example this statement:
SELECT(SELECT 1 Col
FOR XML PATH(''), TYPE).value('.', 'VARCHAR(MAX)')
3
votes
![](https://secure.gravatar.com/avatar/dbc4c136573c2737a8deecb5ac956315?size=40&default=https%3A%2F%2Fassets.uvcdn.com%2Fpkg%2Fadmin%2Ficons%2Fuser_70-6bcf9e08938533adb9bac95c3e487cb2a6d4a32f890ca6fdc82e3072e0ea0368.png)
-
Younes Abesi commented
Resolved. Had Prompt V 3, upgraded to 5, the issue has been resolved.