Copy and Paste! In other words – CTRL + C and CTRL + V – these two are our famous shortcuts for this new age. Remember copy paste is not a bad thing but plagiarism is for sure. I rely on a lot of Copy Paste when I am doing development. There are so many templates, code or name of the objects (tables, stored procedure) etc which we need when we are doing development. If we keep on typing those names, there are chances of making human error which can lead to further problems.
Now the problem with the copy paste is that we can only paste one item which was the last copied. There are often scenarios when we want to paste more than one value without keep on going back again and again to copy them. I was very much delighted when I discovered the shortcut of the Cycle Clipboard Ring and Paste it. However this shortcut is not very popular among developers – CTRL+SHIFT+V. I have created a short video which describes the same.
Let us see the same concept in following SQL in Sixty Seconds Video:
Related Tips in SQL in Sixty Seconds:
- Copy Database With Data – Generate T-SQL For Inserting Data From One Table to Another Table
- Copy Database from Instance to Another Instance – Copy Paste in SQL Server
- Fix : Remote Desktop Copy Paste Stop Working
What would you like to see in the next SQL in Sixty Seconds video?
Reference: Pinal Dave (http://blog.sqlauthority.com)