Format SQL error
Fercasas
Posts: 1 New member
in SQL Prompt
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));
Tagged:
Answers
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-notes
Fixes