What are stored procedures?
Are you preparing for IT certification? With practice questions, study notes, interactive quizzes, tips and technical articles, uCertify PrepKits ensure that you get a solid grasp of core technical concepts to ace your certification exam in first attempt.
What are stored procedures?
Rating:
Stored procedures are precompiled SQL routines that are stored on a database server. They are a combination of multiple SQL statements that form a logical unit and perform a particular task.
Stored procedures provide the capability of combining multiple SQL statements and improve speed due to precompiled routines. Most of the DBMS provide support for stored procedures. They usually differ in their syntax and capabilities from one DBMS to another. A stored procedure can take three parameters: IN, OUT, and INOUT.
Rating:
Was this information helpful?
Other articles
- What is the Scrollable ResultSet object?
- What is the function of the ORDER BY clause in SQL?
- What is a roll back?
- What is the function of the FROM clause?
- What is SAVEPOINT?
