What are the challenges you face when working across database platforms? Take the survey

Format SQL Fails with FOR XML query

MikeyCMikeyC Posts: 249 Bronze 3
edited March 23, 2010 8:56AM in SQL Prompt Previous Versions
SQL Prompt fails with an error saying:

"SQL Prompt was unable to format this script because some syntax errors were found while it was being parsed. These errors have been highlighted."

with this valid code:
SELECT (SELECT 'Test' FOR XML PATH(''), TYPE).value('.[1]','varchar(max)') AS Test


Sign In or Register to comment.