What is a stored procedure in database?
- By Arsal Ahmed March-20-2018
- 751
A stored procedure is a named collection of SQL statements and procedural logic i.e, compiled, verified and stored in the server database. A stored procedure is typically treated like other database objects and controlled through server security mechanism.
- The commands for store procedure is the query
- The new query opens and the store procedures gets created
The procedure like:
Create Procedure Employee details
As
Select * from Employee e INNER JOIN order o ON e. employee WHERE e.employeeID = e.employeeID
When the commands get executed successfully then the folders shows up in the stored procedure folder.
The store procedure folder opens and when the user executes the basic store procedure and it shows that the store procedure has been executed successfully.
