SSMS add comma delimiter - shortcut

Question

Is there a shortcut for adding commas for values for IN clause? e.g. if my query SELECT * FROM Persons WHERE Id IN(.....) and I've copied

356
9874
5975
9771
4166
....

Person's Id values let's say from some Excel file, How can I quickly add ',' comma to the end of each line, so I can paste it IN(....) clause?

Answer 1

Here's what you need to do:

1. Put your cursor one space after the 356 (you'll see what you need that extra space in step 2).
2. Hold down ALT + SHIFT and click the down key for as many numbers as you have. You should see a blue line just to the right of your numbers. This is why you needed the extra space after 356 - so that you can just arrow down the entire list without having to move left or right.

3. Release the keys, and press the comma key. A comma should appear in all of the lines.

You can use this method to add quotes or other characters to your SQL queries as well.

Answer 2

I use this in SSMS 2014;

I am not sure if this can be done in previous versions