Cycle Through Clipboard Ring in SQL Server Management Studio (SSMS) - SQL Server / TSQL Tutorial Part 8

Scenario:

We often copy and past queries to work with them in different Query Windows. Let's say you have close all the Query Windows and would like to go to one of the query you had copied. You can use this feature to go back to 20 items you had copied to clipboard.

Solution:

This is great feature of SSMS, we can cycle through last 20 copied items.
Important Note: If you would have closed the SSMS and reopened, you will not be able to cycle through Clipboard Ring.

Step 1: 
Open a New Query Windows in SSMS. Go to Edit Drop Down and then choose Cycle Clipboard Ring. This will paste copied query to new query window. You can keep repeating to go to previous clipboard copied items.


How to loop through Clipboard Ring in SSMS to recover copied queries- SQL Server Tutorial


Instead of going to Edit and then Cycle Clipboard Ring every time, we can use Ctrl+Shift+V shortcut to paste copied items from clipboard.




2 comments:

  1. it does not take too long to learn good piano playing if you have a good piano lesson,, scooter store london

    ReplyDelete
  2. Ce site de blog est réellement utile pour fournir des événements mis à jour sur Internet, ce qui est réellement appréciable. Bijouterie

    ReplyDelete