Overview
-
Learn how to use SQL Server database triggers to automate routine tasks and facilitate a more consistent, reliable, and predictable system.
Syllabus
-
Introduction
- Automate SQL Server with triggers
- What you should know
- Make the most of the exercise files
- What are SQL Server triggers?
- Two triggers types: INSTEAD OF and AFTER
- Create a trigger to print a message
- Timestamp a table modification
- Firing INSTEAD OF triggers
- Challenge: Create a trigger
- Solution: Create a trigger
- Read values modified by a trigger
- Using the inserted logical table
- Using the deleted logical table
- Triggers on CREATE, ALTER, or DROP
- Rollback database modifications
- Reading the EVENTDATA() XML
- Writing data from the EVENTDATA() function
- Challenge: Create a DDL trigger
- Solution: Create a DDL trigger
- View all triggers in a database
- Enable and disable triggers
- Disable nested triggers
- Recursive triggers
- Reorder trigger execution
- Creating triggers to maintain inventory
- Counting shipments received
- Subtract items sold
- Reorder items when low
- Next steps
