Please enable JavaScript.
Coggle requires JavaScript to display documents.
Procedure - Coggle Diagram
Procedure
-
-
RETURN VS OUTPUT
Return values we can only one return integers. It is not possible, whereas output parameters, can return any data type and a stored procedure can have more than one output parameter.
Execution Plan
An execution plan is nothing but for the query to execute, what are the best possible ways available and it will choose the best possible way based on the indexes that available on the SQL Server to help that query
A stored procedure is a precompiled set of Structured Query Language (SQL) statements with an assigned name and directly saved in the database
Each time we are requesting a sql statement, it is compiled(parsed), this is a time consuming process