Tip 1: Exciting SSMS Features Derived from Visual Studio

Suvendu Shekhar Giri

5.00/5 (3 votes)

Feb 4, 2015

CPOL

1 min read

5419

Exciting SSMS features derived from Visual Studio

In this series of posts, we’ll see few great yet less known and under utilized tips/features that are there since earlier versions of Visual Studio and later made their way to SSMS (SQL Server Management Studio). I am sure you’ll love these tips.

Tip 1: Clipboard Ring – Copy Paste Rediscovered

How many times has it happened that you have copied some text and before pasting it on the desired position /location, copied another chunk of text and then you realized that you lost the previous copy?
Have you ever wished for a feature which could help you to access the text previously copied to clipboard and which should be as simple as the popular copy paste shortcuts?

If you are using Visual Studio 2010 or newer, probably you already know this. Since SSMS 2012, this feature known as “Clipboard Ring” has been introduced. Either of the following two simple keyboard shortcuts will do the job.

CTRL + SHIFT + V

CTRL + SHIFT + INS

Using these shortcuts, you can cycle through the clipboard ring which stores maximum of 20 copy actions.

Hopefully, you liked this tip. Please stay tuned to learn few more exciting tips in this series. I will love to hear from you. Thanks for reading. :)