During last SQL Bangalore user group meeting, Balmukund presented a surprise session of tips and tricks with SQL Server Management Studio. Even though I was not able to attend the event due to travel abroad, I contacted Balmukund to share what he presented. Please note that this feature only works with SQL Server 2012 and onwards.
He was kind enough to give me a list. One of the things which I didn’t know was the usage of vertical block select mode. I have been using block select mode to cut the text by selecting it. This needs a mouse and I found that there is no keyboard shortcut.
Here is what I knew before. To use this, you need to hit the ALT key on the keyboard and then with the help of a mouse, we can select a region in block mode.
Here is what I didn’t know. After choosing a block, we can use the keyboard to type and all rows would have same keys getting typed. It is difficult to explain by words so here is the quick screen capture of what I meant.
Did you know this earlier? Are there any other SQL Server Management Studio tips which you want to share with other reader? User comments section to do that. I am sure there are enough and more we can learn from each other more this way. Every time I have a conversation with friends and attend a session in the UG, I always feel there is something I take back as learning. The experience cannot be expressed in words – trust me.
Reference: Pinal Dave (https://blog.sqlauthority.com)