Monday, October 24, 2016

Query Shortcuts in SQL Server Management Studio


we can create shorcuts in SQL Management Studio. Some of the shortcuts are predefined,

Examples

"Alt + F1" will execute "sp_help"

"Ctrl + 1" will execute "sp_who".

You can create new shortcuts for your own queries

Go to Sql Server Management Studio

Tools --> Options ---> Environment ---> Keyboard ---> Query Shortcuts


For example, you can create a shortcut for:
Syntax
"Ctrl + 3 " : SELECT * FROM  (single space after from keyword)
Use just the  table name in new query and press "ctrl + 3" and query will executed.





at

No comments:

Post a Comment

Thank you for visiting my blog

Subscribe to: Post Comments (Atom)

Kubernetes

Prerequisites We assume anyone who wants to understand Kubernetes should have an understating of how the Docker works, how the Docker images...

  • SUPER AGGREGATES IN SQL SERVER
    Super aggregates: Are used to calculate aggregates of aggregates There are two super aggregates functions Roll Up Cube When there is a singl...
  • Solid Priciples
    SOLID principles allows object oriented programming implementation in an  efficient better way into project development      S-->Single R...
  • Working with PDF IN ASP.NET MVC with Entity FrameWork.
    With this example you can create pdf and print pdf. If You are using ASP.NET MVC , PDF can be created by using Rotativa  Rotativa is a ...