Pages

Wednesday, December 20, 2017

SSMS shortcut for SELECT TOP * FROM

From SQL Authority with Pinal Dave:

SQL Server Management Studio (SSMS) lets you configure the settings you want using a shortcut. Here is how you can do it.

Go to Options, then to Environment. Proceed to Keyboard, and from there, configure your T-SQL with the desired keyword.

A neat trick. After setting this up, you type a table name, highlight it, hit Ctrl-3 (or whatever you set up), and poof, the top 100 rows are up in Query Analyzer (or I guess it's all just SSMS these days).