SQL API Reference - Create Procedure

This page provides documentation for creating SQL API procedures.

Overview

This script allows you to define a procedure for defining and managing SQL types.

The procedure allows for advanced setup, ensuring robust and controlled parameterization.

Step 1: Define the Procedure Name

Enter the name of your procedure (e.g., CreateProcedure).

Step 2: Define the Procedure Body

Enter the procedure body:

        CREATE PROCEDURE CreateProcedure
        (
          @parameter1 INT = 1,
          @parameter2 VARCHAR(255) = 'Hello, World!'
        )
        AS
        BEGIN
          -- Your procedure logic goes here.
          PRINT('Hello from parameter1 and parameter2');
        END;
    

You can access the procedure's body here: https://example.com/sql/api/reference/create-procedure

Step 3: Create the Procedure

Run the script to create the procedure.

The procedure is created successfully.