Drag a box around a vertical selection in SSMS.

This trick of holding Ctrl and Alt together and dragging the mouse works just as well in Microsoft SQL Server Management Studio 2014 as it did back in what must have been Visual Studio 2010 when I wrote the blog posting I refer to here. As an example, if you had the following in a query window in SSMS...

SELECT * FROM Billiards WHERE locale = 1
SELECT * FROM Billiards WHERE locale = 2
SELECT * FROM Billiards WHERE locale = 3
SELECT * FROM Billiards WHERE locale = 4
SELECT * FROM Billiards WHERE locale = 5
SELECT * FROM Billiards WHERE locale = 6

 
 

You could select the word liar in Billiards across all six lines and then type "foo" to change the copy to:

SELECT * FROM Bilfoods WHERE locale = 1
SELECT * FROM Bilfoods WHERE locale = 2
SELECT * FROM Bilfoods WHERE locale = 3
SELECT * FROM Bilfoods WHERE locale = 4
SELECT * FROM Bilfoods WHERE locale = 5
SELECT * FROM Bilfoods WHERE locale = 6

 
 

Warning: When you show this to your coworkers their heads will explode.