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 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.