DEV Community

loading...
Cover image for What is Stored Procedure in SQL

What is Stored Procedure in SQL

Abdur Rehman Khalid
I am a software engineer from the Institute of Management Sciences, Peshawar with Sound practical knowledge of Full-stack web development, PHP, Javascript, SQA and UIUX Designing.
・1 min read

The new capabilities provided by stored procedures, require new disciplines for MySQL developers, only some of whom will have prior experience in stored program development using other relational databases.

what is store procedure

Stored Procedures are pre-compiled code which compiled for first time and its compiled format is saved, we call the compiled saved format whenever we want.

Store Procedure example

How to create store procedure in sql ?

How to create store procedur

Stored Procedure Syntax


CREATE PROCEDURE procedure_name
AS
sql_statement
GO;

Enter fullscreen mode Exit fullscreen mode

Execute a Stored Procedure


EXEC procedure_name; 

Enter fullscreen mode Exit fullscreen mode

Discussion (0)

Forem Open with the Forem app