Displaying calculations in the status bar
I'm mooching this off of SqlRefactorStudio for SSMS, but since I'm really loving my dbForge Studio experience ... as T-SQL proficiency increases across my company, even our accountants are diving straight into SQL coding. They (and therefore I) have an inherent love of highlighting cells in Excel and seeing a number of common math done on the selected region such as SUM, MAX, MIN, and AVERAGE.
SQL Refactor Studio (for SSMS) has this remarkable ability to highlight cells in the result set and display the math dynamically in the status bar. dbForge Studio in all its magnificence doesn't have this ability. IT NEEDS IT!
KJ
shared this idea
-
Daniel Ducharme, Ph.D.
commented
Even worse, Devart's dbForge SQL Complete adds this functionality to SSMS so they are clearly aware of how useful it is and it should be integrated into the main dbForge IDE as well. Right now I find I have to switch back to SSMS in some cases so that I can use dbForge SQL Complete for a number of features that are not present in their custom IDE and this is one of them.
-
KJ
commented
I'll also add that if you add this functionality, consider also adding Excel-like keyboard shortcuts to highlight a row (Shift-Space) or column (Ctrl-Enter) in the result set. That would allow a user to do the math on an entire row or column while still allowing dbForge Studio's existing functionality to sort-by-column.