Help Center > > User Guide> Microsoft SQL Server Database Management (Standard Edition)> Stored Procedure Management> Creating a Stored Procedure

Creating a Stored Procedure

Updated at: Mar 20, 2020 GMT+08:00

Scenarios

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

Prerequisites

You have logged in to the DAS console.

  • You have obtained the CREATE PROCEDURE permission.
  • You have obtained the alter 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, click Set Template Parameter. In the displayed dialog box, set parameters as required and click OK.
  3. Click Execute. In the dialog box, set the input parameters and click Execute.
  4. View the execution status on the Message and Result Set tabs after the execution of the stored procedure.

Did you find this page helpful?

Submit successfully!

Thank you for your feedback. Your feedback helps make our documentation better.

Failed to submit the feedback. Please try again later.

Which of the following issues have you encountered?







Please complete at least one feedback item.

Content most length 200 character

Content is empty.

OK Cancel