Help Center/ Data Admin Service/ User Guide (ME-Abu Dhabi Region)/ User Guide/ Microsoft SQL Server DB Instance Management (Development Tool)/ Database Management/ Stored Procedure Management/ Creating a Stored Procedure
Updated on 2023-03-28 GMT+08:00
View PDF
Share

Creating a Stored Procedure

Overview

A stored procedure is a set of SQL statements used to implement specific functions. After being compiled, stored procedures are stored in databases. You can execute the stored procedures by specifying their names and related parameters.

Scenarios

A stored procedure consists of a set of SQL statements that can complete specific tasks or process complex services. This section describes how to create a stored procedure. You can use loop statements in a stored procedure to insert objects repeatedly.

Prerequisites

You have obtained the CREATE PROCEDURE permission.

Procedure

  1. On the top menu bar, choose Database Management. On the displayed Objects page, select Stored Procedures, and click Create Stored Procedure.
  2. On the displayed page, click Set Template Parameter. In the displayed dialog box, set parameters as required and click OK.
  3. Click Execute. In the dialog box, set input parameters and click Execute.
  4. View the execution status on the Message and Result Set tab pages after the execution of the stored procedure.