Triggers

SQL Server Triggers – Part 2 DDL & LOGON Triggers

Database development, Triggers

In SQL Server, triggers are database objects which will get executed whenever a triggering event...
Read More

SQL Server Triggers: DML Triggers

Database development, Triggers

In SQL Server, triggers are database objects which get executed whenever a triggering event happens on the database or server. Triggers...
Read More

SQL Server Bulk Insert – Part 2

Constraints, Database development, Triggers

In the previous part of this article, we discussed how to import CSV files to SQL Server with the help of BULK INSERT statement. We...
Read More

Logon Triggers in SQL Server

Database development, Triggers

A logon trigger, as the name suggests, is a trigger that fires in response to a LOGON event in SQL...
Read More

SQL Server Trigger: Understanding and Alternatives

Database development, Triggers

The SQL Server trigger is a special type of stored procedures that is automatically executed when an event occurs in a specific database...
Read More

Don’t like database triggers? You just don’t know how to work with them!

Database development, Triggers

When designing large relational databases, we often make a decision to diverge from a normal form, i.e. denormalization. The reasons for...
Read More
Close