Loading…

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

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;

Suggest An Answer

No suggestions avaliable!

Latest post from SQL Interview Questions

Ask Question