Reputation: 57
How to set and use shortcut key in SQL SERVER for execute query ?
select * from tableName
and only type tableName and press key and execute query
Upvotes: 2
Views: 1682
Reputation: 40
you just go to Tool -> Options -> Environment -> Keyboard -> Query Shortcuts and then customize it...
Upvotes: 0
Reputation: 1
SQL Server Management Studio supports custom shortcuts: Tools -> Options -> Keyboard: Among them, Alt + F1, Ctrl + 1, Ctrl + 2 is the system pre-defined shortcut keys.
Upvotes: 0
Reputation: 1156
In SSMS go to
Tool -> Options -> Environment -> Keyboard -> Query Shortcuts
and you can set it up. Remember to leave a space after your command and close exisiting query window. Once shortcuts are set up, you can select your object and press the shortcut combination. It will pick up the query and add your selected object to the end of query and execute complete query.
Upvotes: 2