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

NKeithNKeith Posts: 2 New member
edited June 23, 2020 8:49PM in SQL Prompt

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?

Answers

  • squigleysquigley Posts: 162 Silver 5
    edited 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.

    Sean Quigley | Product Support Engineer | Redgate Software

    Have you visited our Help Center?





  • NKeithNKeith Posts: 2 New member
    I am using SQL Server 2016 version 13.0.16000.28  and SQL Prompt version 9.4.7.7595
Sign In or Register to comment.