Scenario:
You can create shortcut for most commonly used Stored Procedures so you don't have to write every time. You can simple use Shortcut keys to run them.
Solution:
Open SQL Server Management Studio (SSMS). To to Tools and then go to options as shown below.
How to create shortcuts in SSMS For mostly used Stored Procedures - SQL Server Tutorial
Go ahead and add the Stored Procedures in front of Shortcuts. I have added sp_order user Stored Procedure in front of Ctrl+3.
How to create Shortcuts for Stored Procedures in SSMS - SQL Server Tutorial
Once you open the New Query and then Press Ctrl+1, it will run sp_who Stored Procedure. You don't have to worry about scope of database as it will run in any database.
To use the Shortcut for sp_Order , you need to change the Query scope to Database in which sp_Order exists. If you will run in any other database, it will through an error as Stored Procedure will not be present.
This is really an excellent blog as well as its content.
ReplyDeletebest business website designs
This is really a very helpful blog! Thanks for it!
ReplyDeleteThe team has an innate sense for designing an intuitive flow. They’re exceptionally organized.
ReplyDeletebest logo companies
You Guys are really Good
ReplyDeleteThe team regularly accommodates requests, devises creative solutions, and leverages their deep technical expertise.
ReplyDeletebrand design consultancy
Their quick response times, technical expertise, and timely delivery allow for a productive workflow.
ReplyDeletebest web designer
It’s amazing to visit again n again coming to your blogs the superb effort is here.
ReplyDeleteproduct design agency
Thanks to share these details it’s truly nice.
ReplyDeleteinteractive design company
This blog Info is fabulous; I must wanna see best more from your writers.
ReplyDeleteUI UX company
Hand made treasures with sentiment from New Orleans statement rings
ReplyDelete