Welcome to MSSQL Forum!
MSSQL Forum - Discussions about Microsoft SQL Server

You are currently viewing our community forums as a guest user. Sign up or
Having an account grants you additional privileges, such as creating and participating in discussions.

Repeat the same operation on multiple lines in SSMS

Discussion in 'SQL Server Scripts and Tools' started by Peter Schmitz, Feb 22, 2016.

  1. Peter Schmitz

    Peter Schmitz Administrator Staff Member

    Suppose the following scenario happens. Finance sends you a list of invoice numbers and asks you to pull data on them. So you fire up SSMS, copy and paste in the list of invoices, and m,anually start adding start- and end quotes as well as commas around them. First row: Press Home to start at the beginning of the line, add a quote, Press End to go to the end of the line, press quote, press the Down arrow, Press Home, Press comma, press space, press quote, etc.

    There's an easier way to do operations on multiple lines, though.

    Start by copy/pasting in the invoice numbers:

    upload_2016-2-22_9-12-7.png

    Position your mouse at the beginning of the second line (the first one to contain the invoice number). Then hold down Alt, and drag your mouse down to the last row of invoices, ensuring you stay in front of the first character of the lines. Note the thin blue line in front of the lines to indicate you marked the lines:

    upload_2016-2-22_9-13-46.png

    Now press the Quote key to instantly add a quote to the beginning of every line:

    upload_2016-2-22_10-9-35.png
    Press the End key, hold down ALT again and drag your mouse along the space behind every last character , and then press the quote key again to add a quote at the end of every line:

    upload_2016-2-22_10-11-54.png

    Skip down to line number 3, and repeat to add a comma and a space in front of every new invoice number.

    This trick undoubtedly is going to save me heaps of time, and I hope you'll find it equally useful to cut short some boring repetitive tasks.

Share This Page