{"id":71,"date":"2011-08-12T09:30:23","date_gmt":"2011-08-12T09:30:23","guid":{"rendered":"https:\/\/sqlserverlearner.azurewebsites.net\/2011\/08\/12\/steps-to-setup-query-shortcuts-in-sql-server\/"},"modified":"2011-08-12T09:30:23","modified_gmt":"2011-08-12T09:30:23","slug":"steps-to-setup-query-shortcuts-in-sql-server","status":"publish","type":"post","link":"https:\/\/sqlserverlearner.com\/2011\/08\/12\/steps-to-setup-query-shortcuts-in-sql-server\/","title":{"rendered":"Steps To Setup Query Shortcuts in SQL Server"},"content":{"rendered":"
SQL Server Management studio provides a very useful functionality called query shortcuts<\/strong>. This makes the task of querying the sql server easier. Just by pressing two keys on the keyboard a complex query can be executed.<\/p>\n Lets take a scenario where a query is very frequently used.<\/p>\n Lets suppose the query to be Now instead of writing the query every time and executing it a query short cut can be setup for this query.<\/p>\n Steps to setup query shortcut in SSMS in detail:<\/strong><\/p>\n 1) Select tools menu and then select options<\/p>\n 2) In the options expand environment and then click on Keyboard.<\/p>\n 3) In the query shortcuts plane give the query in the Stored Procedures section for one of the shortcuts.<\/p>\n
\n[sql]
\nSELECT top 10 * FROM PRODUCTS
\n[\/sql]<\/p>\n