The difference between Procedure and Stored procedure
When used as nouns, procedure means a particular method for performing a task, whereas stored procedure means a named program or routine stored in a database.
check bellow for the other definitions of Procedure and Stored procedure
-
Procedure as a noun:
A particular method for performing a task.
-
Procedure as a noun:
A series of small tasks or steps taken to accomplish an end.
-
Procedure as a noun (uncountable):
The set of established forms or methods of an organized body for accomplishing a certain task or tasks.
Examples:
"Ensure that you follow procedure when accessing customers' personal information."
-
Procedure as a noun:
The steps taken in an action or other legal proceeding.
-
Procedure as a noun (obsolete):
That which results; issue; product.
Examples:
"rfquotek Francis Bacon"
-
Procedure as a noun (computing):
A subroutine or function coded to perform a specific task.
-
Procedure as a noun (medicine):
A surgical operation.
-
Stored procedure as a noun (databases):
A named program or routine stored in a database.
Examples:
"I think the overflow bug is in your stored procedure."