Stored Procedure in SQL

 What is a stored procedure?

   -> A set of of SQL statements stored and executed on the database server.

Benefits of stored procedures :

1- Reduction in network traffic

2- Improvement in performance

3- Reuse of code

4- Increase in security

How to work with stored procedures:

Call from:

a) Dynamic SQL statements

b) External applications

For example:CALL UPDATE_SAL("E1001", 1)