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
Younes Abesi
shared this idea
-
Younes Abesi commented
Resolved. Had Prompt V 3, upgraded to 5, the issue has been resolved.