Creating shortcut key in sql server

Keyboard shortcuts can boost our productivity if our daily job relies heavily. They just don’t get the work done quickly, but also improves the efficiency.

Let’s see how to create a short cut key in sql server

Open SSMS.

Go to tool

  

Click on Option

  

Go->Environment ->Keyboard->Query Short cuts

On Query short cuts we can write our sql query. Here I wrote the select * from [SalesLT].[Address]  from the database AdventureWorksLT2008.  Now click ok.

Now I am running this using short cut key. Open the new query windows and press

   

Note:  we need to run this under AdventureWorksLT2008 database.

   

Oh!!! We are getting the expected result.

We can also write the completed sql query including different databases.

Select * from AdventureWorksLT2008.SalesLT.Address

Select * from AdventureWorksDW2008R2.dbo.DimEmployee

   

We can also create the short cut key for stored procedure and functions.

    

Running

  

Got the result.