12. Triggers and Audit Trail - Designing Database Solutions with Microsoft SQL Server 2022
1.9 هزار بار بازدید -
پارسال
-
In this lesson, Joed Goh
In this lesson, Joed Goh explains the use of Triggers in Microsoft SQL Server. Triggers are commonly used to maintain data integrity, control server operations, or perform auditing tasks to strictly implement business rules.
This lesson demonstrates how to create DML triggers to perform basic auditing actions on a table when DML commands such as INSERT, UPDATE, or DELETE operations are being performed.
Table of Contents:
00:00 Introduction
01:14 AFTER Trigger (INSERT)
04:45 AFTER Trigger (DELETE)
05:41 AFTER Trigger (UPDATE)
07:36 The UPDATE() Function
10:35 INSTEAD OF Trigger (DELETE)
PLAYLISTS:
Designing Database Solutions with Microsoft SQL Server 2019
• Designing Database Solutions with Mic...
Artificial Intelligence and Machine Learning Foundations
• Artificial Intelligence and Machine L...
IoT Development
• Internet of Things
Android App Development in Kotlin
• Android App Development in Kotlin
Embedded Systems using Arduino Uno
• Embedded Systems using Arduino Uno
Data Structures and Algorithms using C#
• Data Structures and Algorithms
پارسال
در تاریخ 1402/03/18 منتشر شده
است.
1,948
بـار بازدید شده