vpruthi/doc-exports
1
0
Fork 0
forked from docs/doc-exports
Code Pull Requests Activity
doc-exports/docs/das/umn/das_13_0060.html
Wang , Deng Ke 0f41701050 DAS UMN Initial version 
Reviewed-by: gtema <artem.goncharov@gmail.com>
Co-authored-by: Wang , Deng Ke <wangdengke2@huawei.com>
Co-committed-by: Wang , Deng Ke <wangdengke2@huawei.com>
2022-10-18 12:51:00 +00:00

2.0 KiB
Raw Permalink Blame History

Creating a Stored Procedure

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 ROUTINE permission.
  • You have obtained the Execute permission.

Procedure

  1. On the top menu bar, choose Database Management. On the displayed Objects tab, choose Stored Procedures on the left and click Create Stored Procedure in the right pane.
  2. On the displayed page, enter the stored procedure name and type, and click OK.
  3. On the displayed page, enter the stored procedure information and click Save.