بسم الله الرحمن الرحيم

تحليل وتصميم وبناء أنظمة قواعد البيانات باستخدام

رابط الدرس:

Syllabus:

Stored Procedure and Functions

Basic Concepts of Stored Procedure

Stored procedure definition

Stored procedure benefits

Stored procedure types

User-defined stored procedures

System stored procedures

Using the CREATE PROCEDURE statement

Using the ALTER PROCEDURE statement

Using the DROP PROCEDURE statement

Working with Functions

Basic Concepts of Functions

Function definition

Function benefits

Function types

Creating and Calling Functions

Function Calling

Creating a Scalar-Valued function

Creating a Table-Valued function

Creating a Multi-statement Table-Valued function

Modifying and Removing Functions

Triggers

Working with Triggers

Trigger definition and types

DDL triggers

DML triggers

DML trigger benefits

Managing INSTEAD OF triggers

Creating INSTEAD OF triggers

Modifying and removing triggers