What has stored procedures in SQL and how we can use it?

1.	What has stored procedures in SQL and how we can use it?
Answer» It is a SET of precompiled SQL STATEMENTS that are used to perform a particular TASK. A procedure has a name, a PARAMETER list, and SQL statement, etc. It will help in reduce network traffic and increase the performance. Example CREATE PROCEDURE simple_function AS SELECT first_name, last_name FROM employee; EXEC simple_function;

Discussion