Applying Quotes Across Multiple Lines in SSMS
<p>Is there a keyboard function that applies single quotes across a list of values? I have 10 IDs that I have copied from an Excel spreadsheet and I would like to execute a query that uses an IN clause on this list, and I don't want to manually add single quotes and comma around each item.</p>

<p>For example:</p>

<pre><code>SELECT * FROM tbl WHERE someValue IN (
ABC1
ABC2
ABC3
ABC4
)
</code></pre>

<p>I want to highlight the values and using a keyboard shortcut turn the list into:</p>

<pre><code>SELECT * FROM tbl WHERE someValue IN (
'ABC1',
'ABC2',
'ABC3',
'ABC4'
)
</code></pre>

<p>I got how to get quote in the beginning using SHIFT + ALT (select the list and type single quote <strong>'</strong>)
Courtesy: <a href="https://dba.stackexchange.com/questions/96371/applying-quotes-across-multiple-lines/96378#96378?newreg=5c3f55c24a924dd28cd9834ad8a625ae">Link</a>.</p>

<p>But how to do the same at the end of each item to add a single quote and comma (<strong>',</strong>)</p>

<p>Thank you in advance</p>