LinkedIn

Inserted and Deleted Tables in SQL Server

In this article, I am going to discuss Inserted and Deleted Tables in SQL Server with examples. Please read our previous article where we discussed the basics of SQL Server Triggers in detail. So, ...
LinkedIn

SQL Server Trigger for Logging Salary Updates

This SQL script demonstrates a trigger that logs salary updates into a separate table. It’s a standard example of using AFTER UPDATE triggers with inserted and deleted pseudo-tables in SQL Server.
GitHub

SQL Server project that implements automatic database backup using a database trigger, stored procedure, and SQL Agent job scheduling.

There was an error while loading. Please reload this page. -- Auto Backup for SQL Server - Fixed Version -- Replace MyDB with your database name and ensure C:\DB ...
GitHub

Invoke-SqlServer-Persist-TriggerDDL.psm1

This script can be used backdoor a Windows system using a SQL Server DDL event triggers. As a result, the associated TSQL will execute when any DDL_SERVER_LEVEL_EVENTS occur. This script supports the ...
IEEE

Research on SQL Server trigger to implement referential integrity

Abstract: Database integrity is an important research content of database security, triggers can enforce the more complex referential integrity, and this paper studies the approach of using DML ...