SQL Prompt adding Quotes at end of list not around criteria and won't add commas

NKeith · June 23, 2020 7:14PM

If I have this ('100' '103' '104' '172' '174') --- (Note No Commas and I am using SQL Server)

and select Add quotes, nothing happens and if I select "add quotes and commas" I get this-- '(''100'' ''103'' ''104'' ''172'' ''174'')'I need it to do this ( '100', '103' , '104', '172', '174' ) why did it stop doing this formatting and how can I fix it? UPDATE - A coworker said this happened to him as well and he thinks it is something to do with when we copy and paste from excel - where it basically wraps lines in quotes. How can we correct this?

squigley · June 24, 2020 11:01PM

Good Afternoon!

Thanks for your inquiry and sorry to hear about your issue with SQL Prompt.

Can you confirm what version of SQL Prompt and SQL Server that this involves? I want to see if I can replicate this on my end.

NKeith · June 25, 2020 1:36PM

I am using SQL Server 2016 version 13.0.16000.28 and SQL Prompt version 9.4.7.7595

squigley · August 26, 2020 10:27PM

Good Afternoon,

Thanks for sending those details regarding the versions involved.

Can you confirm that you encounter the same issue if you upgrade to the latest version of SQL Prompt?

Download Link: https://download.red-gate.com/checkforupdates/SQLPrompt/SQLPrompt_10.3.7.15732.exe

Upgrade Documentation: https://documentation.red-gate.com/sp/upgrading

The reason why I ask to try upgrading is that the version you're using is from almost two years ago and the developers are not likely to fix the issue unless it also occurs on the latest versions of the tool as well.

Thanks!

SQL Prompt adding Quotes at end of list not around criteria and won't add commas

Answers

Product Learning

Community Forums

Events & Friends

Simple Talk