When I use WITH in a FROM OPENXML statement it generates an error when trying to format it:
SELECT code1
FROM OPENXML(@DocHandle, '/reports/report', 0)
WITH (code1 VARCHAR(2));


Comments
1 comment
-
This issue should now be resolved as of patch release v10.13.12
Download link here:
https://download.red-gate.com/checkforupdates/SQLPrompt/SQLPrompt_10.13.12.1701.exe
Patch notes:
https://documentation.red-gate.com/sp/release-notes-and-other-versions/sql-prompt-10-13-release-notesFixes
- Fixed an issue where OPENXML statement wasn't recognized in Azure SQL Database.
- Fixed an issue where OPENXML statement wasn't recognized in Azure SQL Database.
Add comment
Please sign in to leave a comment.