This video demonstrates the steps to create a stored procedure that accepts a parameter. <br />A stored procedure is a set of Structured Query Language (SQL) statements with an assigned name,<br /><br />which are stored in a relational database management system as a group, so it can be reused and shared by multiple programs.<br /><br />There are so may advantages of using Stored procedures. It manage, control and validate data. Large queries can be avoided. <br /><br />It reduces network traffic since they need not be recompiled. Hence stored procedures increases re-usability of code.<br /><br />Permissions can be granted for stored procedures. Hence, increases security.<br />Thank you for watching SQL SERVER 2017 TUTORIAL: PART 05 (STORED PROCEDURE)
