Options
SQL Prompt Semicolon Duplication
JRiedemann
Posts: 3 Bronze 1
in SQL Prompt
I'm using SQL Prompt 9.5.20.11737 in both VS 2019 and SSMS 17.9. In both environments, when I "Insert Semicolons" it adds a semicolon to the end of every statement, whether there is one there already or not. I now have a statement that looks like "CREATE TABLE (...);;;;". Obviously I would only want one semicolon on any statement. Is this a bug or a config issue?
Tagged:
Answers
Hello @JRiedemann ,
I've just tested this feature in 9.5.21.11921 using a simple CREATE TABLE script and it worked as expected using the default options. There were no duplicate semicolons inserted even when there were semicolons already in the script. Can you please provide a sample script that reproduces the issue on your end? Also, are you using the default SQL Prompt options as well as the default formatting style? If not, can you please share your options so I can try and reproduce this? I didn't see anything related in the release notes but might be worth upgrading to 9.5.21.11921 just in case.
SQL Prompt download link:
https://download.red-gate.com/checkforupdates/SQLPrompt/SQLPrompt_9.5.21.11921.exe
Kind regards,
Pete Ruiz