SQL SERVER – Denali – Clipboard Ring – CTRL+SHIFT+V

While I was writing my earlier post SQL SERVER – 2011 – Multi-Monitor SSMS Windows, I found out that there is one more similar feature which existed in Visual Studio is also now part of SQL Server 2011 (Denali). The feature is called clipboard ring feature.

This is how it works.

Select Multiple object one by one using regular CTRL + X.

Now instead of pasting using CTRL+V use CTRL+SHIFT+V. Well, you will see that that pasted value is rotating based on what you have earlier selected in CTRL+V. I was really happy as I think this is one of the feature of VS, I really wanted SSMS to have.

Try it and let me know what you think of the same.

Reference: Pinal Dave (https://blog.sqlauthority.com)

Previous Post
SQL SERVER – Denali – Multi-Monitor SSMS Windows
Next Post
SQL SERVER – Reducing Page Contention on TempDB

Related Posts

2 Comments. Leave new

  • Yes, This is very interesting feature for clip boards.. You can do multiple copies and pastes at a time.. It maintains history of copies.

    Friends One more interesting feature which I always use, is Block Selection. We can select columns(instead of lines) of paragraph. By selecting with Holding Alt key
    i.e : In this paragraph you can select “a e i m” by pressing alt key while selecting either with keyboard or mouse… I just love this feature to write “IN” query…

    abcd
    efgh
    ijkl
    mnop

    again.. you can also select
    bc
    fg
    jk
    no

    from this paragraph
    ….

    Thanks Pinal for sharing …
    B’Regards,
    Ishrar.

    Reply

Leave a Reply

Menu