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.
SQL CREATE PROCEDURE Syntax
SQL
x
1
CREATE PROCEDURE procedure_name
2
AS
3
sql_statement;
SQL CREATE PROCEDURE Example
This query creates a procedure named SelectAllPatients
to select all records from the Patients
table.
SQL
1
1
CREATE PROCEDURE SelectAllPatients
2
AS
3
SELECT * FROM Patients;
Note: This code does not work in TechKubo playground. SQLite (and therefore TechKubo) does not support stored procedures.
SQL EXEC Procedure Syntax
SQL
1
1
EXEC procedure_name;
SQL EXEC Procedure Example
This query executes the SelectAllPatients
procedure.
SQL
1
1
EXEC SelectAllPatients;
Note: This code does not work in TechKubo playground. SQLite does not support executing stored procedures using
EXEC
.