Format clipboard for IN query
Often we'll do a query e.g. SELECT Id from Table where param LIKE '%Foo%'
Then we'll want to copy and paste those Ids in to a separate query
DELETE FROM Table WHERE Id in (.......)
It would be good if there was a way SQL Prompt could help format the clipboard paste into a comma-separated list.
(I appreciate this example would be simple to refactor as a JOIN)
Thank you for your suggestion.
We’ve reviewed this as part of our UserVoice triage.
Currently, we have no plans to implement this feature in the near future, as it does not align with our current work.
The Prompt Team
Yes, that works too. Still a bit of a pain for larger/longer queries or even copying and pasting from e.g. Excel.