I understand that in SQL Server Management Studio (SSMS), it’s possible to right-click and use the command SELECT TOP ROWS
on any table. Is there a method to modify this default command so that it automatically sorts the returned rows using ORDER BY 1 DESC
? My goal is to streamline my workflow, possibly like this:
Right-click - SELECT TOP ROWS ORDER BY 1 DESC
Alternatively, would I need to utilize a snippet to insert after receiving the data, or perhaps associate a stored procedure with a keyboard shortcut? Thank you for your assistance!