562 attributed reviews in the last 3 years
Refreshingly small course sizes
Outstandingly good courseware
Whizzy online classrooms
Wise Owls only (no freelancers)
Almost no cancellations
We have genuine integrity
We invoice after training
Review 30+ years of Wise Owl
View our top 100 clients
Triggers in SQL Server
Part one of a four-part series of blogs
Triggers are special stored procedures that execute automatically in response to certain events in a database. This blog explains how to create three types of trigger in SQL Server: DML, DDL and Logon triggers.
This blog is part of our free SQL Server tutorial.
In SQL Server, a trigger is a special type of stored procedure which will run automatically in response to some kind of event in the database.
There are three main types of trigger in SQL Server, as described in the table below:
|DML Trigger||DML, or Data Manipulation Language triggers respond to events which manipulate the data in your database. Typically, this type of trigger would be attached to events such as INSERT, UPDATE or DELETE statements which change the data in a table or a view.|
|DDL Trigger||A DDL, or Data Definition Language trigger would be executed when objects within a database are modified. CREATE, ALTER and DROP are good examples of statements which could execute a DDL trigger.|
|Logon Trigger||Logon triggers are fired when a user session is being established.|
This blog covers all three types of trigger, starting with the DML variety on the next page.
|Parts of this blog|
25 Aytoun Street