Stored Procedure SP or Procedure is a collection/batch of SQL statements stored inside a database.
A SP is faster due to pre-compiled property that makes it to follow the same execution plan as it has followed earlier and the already saved one, instead of again checking for the best execution plan.
A SP may return or may not return a output and cannot be called inside a select statement,
Here, we have defined simple SP and SP with Input Parameters.
Please do not forget to comment the SP query, asked at the last of the video.
