What is a stored procedure in database?
What is a stored procedure in database?
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.
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.
Share This with your friend by choosing any social account
You may also read following recent articles
![]() |
Is Chat GPT Use Of Web Content Fair!
Junaid A 29-Jan-2023 |
![]() |
Office politics examples!
Junaid A 28-Jan-2023 |
![]() |
ten jokes about the status of ChatGPT!
Junaid A 17-Jan-2023 |
![]() |
Image Resizing On Uploadig!
shahid Riaz 02-Jan-2019 |
![]() |
Hosting Server Connect Timeout!
Junaid A 13-Apr-2018 |
![]() |
What I can do after BS!
12-Apr-2018 |
|
Best hosting for windows!
05-Apr-2018 |
![]() |
Why cv is rejected!
30-Mar-2018 |
|
How to Integrated The Theme in Project!
shaheer 27-Mar-2018 |
![]() |
How to perform crud operations in asp.net?!
27-Mar-2018 |
![]() |
How to perform crud operations in asp.net?!
27-Mar-2018 |
![]() |
What is outer join in database?!
Arsal Ahmed 20-Mar-2018 |
![]() |
What is right join in database?!
Arsal Ahmed 20-Mar-2018 |