Copy (CTRL + C) and Paste (CTRL + V) are the friends of the DBAs and Developers. However, sometimes we need more help with copy and paste. There have been moments where I have felt that I should copy and paste and multiple values one after another but I should not be able to keep on going back and forward. Honestly, in SQL Server it is totally possible if you use the feature of the Cycle Clipboard Ring.
You can see how this works in action in the attached SQL in the Sixty Seconds Video. The copy of the string is straight forward with the help of the (CTRL + C). However, the paste requires an additional step of (CTRL + SHIFT + V).
In SQL Server Management Studio this is available under the Edit field. Here is the screenshot for the same for Cycle Clipboard Ring.
If you like my videos, I request you to like, share, comment, and subscribe to these videos. Here is the link to my YouTube Videos.
Here are a few additional SQL Server Videos:
- CONCAT and NULL – SQL in Sixty Seconds #123
- Sleeping vs Suspended Process – SQL in Sixty Seconds #122
- Pinned Tab – SSMS Efficiency Tip – SQL in Sixty Seconds #121
- Split Screen for SSMS Efficiency – SQL in Sixty Seconds #120
- Nonclustered Primary Key – SQL in Sixty Seconds #119
- Recent Execution of Stored Procedure – SQL in Sixty Seconds #118
- Full-Screen Execution Plan – SQL in Sixty Seconds #117
- Recover Crashed Query in SSMS – SQL in Sixty Seconds #116
- Activity Monitor and Running Query – SQL in Sixty Seconds #115
- Email an Execution Plan – SQL in Sixty Seconds #114
- Execution Plan – Estimated vs Actual – SQL in Sixty Seconds #113
- Who Dropped Your Table? – SQL in Sixty Seconds #112
- Single Column Single Row and TABLE SCAN – SQL in Sixty Seconds #111
- Dirty Read with NOLOCK – SQL in Sixty Seconds #110
Reference: Pinal Dave (https://blog.sqlauthority.com)