{"id":446,"date":"2024-08-28T08:49:15","date_gmt":"2024-08-28T08:49:15","guid":{"rendered":"https:\/\/techkubo.com\/sql\/?p=446"},"modified":"2025-05-27T09:46:13","modified_gmt":"2025-05-27T09:46:13","slug":"create-procedure","status":"publish","type":"post","link":"https:\/\/techkubo.com\/sql\/create-procedure\/","title":{"rendered":"CREATE PROCEDURE"},"content":{"rendered":"\n

SQL CREATE PROCEDURE Keyword<\/h2>\n\n\n\n

The CREATE PROCEDURE command is used to define a stored procedure. A stored procedure is a pre-written block of SQL code that can be executed repeatedly to perform specific tasks such as querying data or modifying tables.<\/p>\n\n\n\n

<\/p>\n\n\n\n

SQL CREATE PROCEDURE Syntax<\/h2>\n\n\n\n
CREATE PROCEDURE procedure_name\nAS\nSQL statements<\/pre><\/div>\n\n\n\n
<\/p>\n\n\n\n
SQL CREATE PROCEDURE Example<\/h2>\n\n\n\n
This procedure is intended to return all records from the Patients table each time it is executed.<\/p>\n\n\n\n
CREATE PROCEDURE SelectAllPatients\nAS\nSELECT * FROM Patients\nGO<\/pre><\/div>\n\n\n\n
<\/p>\n\n\n\n
Execution<\/strong>:<\/p>\n\n\n\n
This runs the stored procedure and displays the result of the query.<\/p>\n\n\n\n
EXEC SelectAllPatients<\/pre><\/div>\n\n\n\n
\n
Note:<\/em><\/strong> This example will in the TechKubo playground. SQLite does not support CREATE PROCEDURE<\/strong> or stored procedures. Stored procedures are supported in other systems like SQL Server MySQL and Oracle.<\/p>\n<\/blockquote>\n\n\n\n
<\/p>\n\n\n\n
SQL CREATE PROCEDURE Labs<\/h2>\n\n\n\n