SQL SERVER 2017 TUTORIAL: PART 05 (STORED PROCEDURE)

Hosted by Dailymotion. For legal issues report at the Copyright Center, report us on DMC, or use the Instant Removal tool.

SQL SERVER 2017 TUTORIAL: PART 05 (STORED PROCEDURE)

F
FAST tech

2 Views • May 23, 2018

Description

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)