Chapter 18. Data manipulation triggers
After completing this chapter, you will be able to
Explain the different types of triggers.
Create, alter, and drop triggers.
Explain practical uses of triggers.
Data manipulation triggers are sets of T-SQL statements that perform a specific action. They are often referred to as a special kind of stored procedure. Unlike stored procedures, triggers are executed only when a user or application attempts to modify data using Data Manipulation Language (DML). DML includes INSERTs, UPDATEs, and DELETEs against views and tables.
In this chapter, you will look at different types of DML triggers. You will learn how to create, modify, and drop triggers. Finally, you will walk through the steps to enable or disable an existing ...
Get Microsoft® SQL Server® 2012 Step by Step now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
