Scribd
Upload
3 views4 pages

Understanding Stored Procedures in SQL

The document introduces Stored Procedures, defining them as subroutines stored in a database with a name, parameter list, and SQL statements. It provides the general syntax for creating and calling a stored procedure. Additionally, it hints at use cases for stored procedures, though specifics are not detailed in the provided content.

Uploaded by

Rkpande20
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
3 views4 pages

Understanding Stored Procedures in SQL

The document introduces Stored Procedures, defining them as subroutines stored in a database with a name, parameter list, and SQL statements. It provides the general syntax for creating and calling a stored procedure. Additionally, it hints at use cases for stored procedures, though specifics are not detailed in the provided content.

Uploaded by

Rkpande20
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd

#56daysofSQL

Day 1

Stored Procedure

(Intro)

Aditya Shenoy
#56daysofSQL

What are Stored

Procedures

A Stored Procedure is a

subroutine in a regular computing

language, stored in database.

A Procedure has a name, a

parameter list, and SQL

statement(s).

Aditya Shenoy
#56daysofSQL

General Syntax :

DELIMITER //

CREATE PROCEDURE procedure_name()


BEGIN
--- statements ---
END //

DELIMITER ;

CALL procedure_name();

Aditya Shenoy
#56daysofSQL

Use Case :

Aditya Shenoy

You might also like