You can use the SQL editor to create stored procedures.
Before you begin
Ensure the following requirements are met:
About this task
With the SQL Editor, you can create a stored procedure
based on a template, then modify the code in the editor as needed.
This method is useful if you want to quickly create a stored procedure
and run it on the server.
Procedure
To create a stored procedure from the Data Source Explorer:
In the Data Source Explorer, right-click the Stored
Procedures folder under a database connection, and click .
Results
The SQL editor opens, initialized with a sample stored procedure.
What to do next
Modify the sample stored procedure code as needed and run
the stored procedure from the SQL editor view to deploy the stored
procedure to the database.