- SQL Introduction
- SQL Select Query
- SQL Where Query
- SQL Joins Query
- SQL Update
- SQL Count
- SQL Sum
- SQL Operators
- SQL Like
- SQL Group By
- SQL Insert Into
- SQL Inner Join
- SQL Left Join
- SQL Right Join
- SQL Full Join
- SQL Exists
- SQL Null
- SQL Stored Procedures
- SQL Any
- SQL Self Join
- SQL Top Statement
- SQL Delete
- SQL Order By
SQL Stored Procedures.
Stored Procedures in SQL, is a group of SQL statements that are stored together in a database.
Based on the statements in the procedure and the parameters you pass, it can perform one or multiple DML operations on the database, and can return value.
It allows you to pass the same statements multiple times, thereby, enabling reusability.