Double and Triple-Click in SQL Server are two very useful shortcuts to save you time and reduce errors
This is one of the simplest and possibly most frequent timesavers we use in SQL Server
Using Double-Click in SQL
Double click is a SQL server shortcut that can save you time and effort when writing SQL queries. With this timesaver, you can quickly select a word or phrase in your query without having to manually move the cursor and highlight the text.
This shortcut is especially useful when dealing with long and complex queries
One frequently used benefit of double click is when you need to quickly replace a field name in a SQL query. In this case you can copy the field name you want to use to the clipboard using the usual Ctrl + C command, then double click the field name you need to replace, this selects that old, then finally Ctrl + V paste the name field name from the clipboard over the old field name
Using Triple-Click in SQL Server
Triple-click is another widely used timesaver, this is used to select an entire row
by left clicking three times with the mouse anywhere on a row, the whole row is selected
This can be useful you only want to run that single row of code, or is a good starting point to select a continuous range of rows
Subscribe to our channel to see more tips and timesavers
Select Distinct YouTube Channel
Or find other useful SQL, Power BI or other business analytics timesavers in our Blog
Our Business Analytics Timesavers are selected from our day to day analytics consultancy work. They are the everyday things we see that really help analysts, SQL developers, BI Developers and many more people.
Our blog has something for everyone, from tips for improving your SQL skills to posts about BI tools and techniques. We hope that you find these helpful!
