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