Competition: What’s your favorite Redgate tool? Enter now.

Format SQL Fails with FOR XML query

CodantiMCodantiM Posts: 245
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.