Creating stored procedures from the Data Source Explorer

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 New > With SQL Editor.

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.

Feedback