PROCEDURE

SQL CREATE PROCEDURE Keyword

The CREATE PROCEDURE command is used to create a stored procedure. A stored procedure is a prepared SQL block that you can save and reuse to perform a task repeatedly.

Tutorials dojo strip

SQL CREATE PROCEDURE Syntax

SQL

SQL CREATE PROCEDURE Example

This query creates a procedure named SelectAllPatients to select all records from the Patients table.

SQL

Note: This code does not work in TechKubo playground. SQLite (and therefore TechKubo) does not support stored procedures.

SQL EXEC Procedure Syntax

SQL

SQL EXEC Procedure Example

This query executes the SelectAllPatients procedure.

SQL

Note: This code does not work in TechKubo playground. SQLite does not support executing stored procedures using EXEC.

SQL PROCEDURE Labs

Tutorials dojo strip