Skip to main content

SQL Server 2014 Keyboard Shortcut Keys in Management Studio

Open New Query Window (Ctrl + N)

Shortcut key to open new query window in sql server management studio is Ctrl + N. It will open new key query window in current connection.

Execute Highlighted Query (Ctrl + E)

If want to execute highlighted or selected query in sql server management studio shortcut key is Ctrl + E.

Toggle between Open Tabs (Ctrl + Tab)

If we want to toggle or switch between opened tabs in sql server management studio shortcut key isCtrl + Tab. It will help us to move between opened tabs easily.

Show / Hide Result Pane (Ctrl + R)

By using Ctrl + R shortcut key we can show / hide result pane of executed query. We can easily make full screen by hiding / closing result pane using shortcut key Ctrl + R.

Display Estimated Execution Plan (Ctrl + L)

If we want to show execution plan for queries which we are executing shortcut key is Ctrl + L. If we use Ctrl + L key combinations automatically it will show estimated execution plan for current executed queries.

Go to Particular Line (Ctrl + G)

If you want to go to particular line of query or get line number of query which we placed cursor shortcut key is Ctrl + G. By using this shortcut key we can easily get line numbers of query code in sql servermanagement studio.

Cancel Execution of Query (Alt + Break)

By using Alt + Break shortcut key we can stop execution of query in sql server management studio.
Labels:

Comments

Post a Comment

Popular posts from this blog

Top 10 ASP.NET Web API Interview Questions

What is ASP.NET Web API? ASP.NET Web API is a framework that simplifies building HTTP services for broader range of clients (including browsers as well as mobile devices) on top of .NET Framework. Using ASP.NET Web API, we can create non-SOAP based services like plain XML or JSON strings, etc. with many other advantages including: Create resource-oriented services using the full features of HTTP Exposing services to a variety of clients easily like browsers or mobile devices, etc. What are the Advantages of Using ASP.NET Web API? Using ASP.NET Web API has a number of advantages, but core of the advantages are: It works the HTTP way using standard HTTP verbs like  GET ,  POST ,  PUT ,  DELETE , etc. for all CRUD operations Complete support for routing Response generated in JSON or XML format using  MediaTypeFormatter It has the ability to be hosted in IIS as well as self-host outside of IIS Supports Model binding and Validation Support for OD...
2 comments
Read more

First, FirstOrDefault, Single, SingleOrDefault In C#

For people who are new to LINQ, it is difficult to understand the difference between First, FirstOrDefault, Single, SingleOrDefault. In this blog, I will explain what to use and when.     I will take a simple example to make you understand practically how these methods work.   Consider a class Employee with properties as Id, Name, and Department. class  Employee {    public   int  Id {  get ;  set ; }    public   string  Name {  get ;  set ; }    public   string  Department{  get ;  set ; } } I have a list of Employees: List<Employee> employeeList =  new  List<Employee>(){    new  Employee() { Id = 1, Name =  "Sunny" , Department =  "Technical"  },    new  Employee() { Id=2, Name= "Pinki" , Department = "HR" },    new  Employee() { Id=3, Name= "Tensy" , De...
3 comments
Read more

Extension methods in C#

Consider the class C# 1 2 3 4 5 6 7 8 9 10 11 12 13          namespace ExtensionMethod      {          public class testClass {              public string sayHello ( ) {              return "Hello" ;            }        }      }     Invoke the above from your form using C# 1 2 3 4 5 6          testClass test = new testClass ( ) ;      MessageBox . Show ( test . sayHello ( ) ) ;     This will show “Hello” in message box. Consider the scenario where you don...
5 comments
Read more