Collections:
"CREATE TRIGGER" - Creating a DML Trigger in SQL Server
How To Create a DML Trigger using CREATE TRIGGER Statements in SQL Server?
✍: FYIcenter.com
A DML trigger is a trigger declared to handle a DML event, which occurs when an INSERT, UPDATE or DELETE statement is executed. If you want to create a DML trigger, you should use the "CREATE TRIGGER" statement in the following format:
CREATE TRIGGER trigger_name ON table_name AFTER INSERT, UPDATE, DELETE AS statements GO
The tutorial exercise below shows you a very simple DML trigger defined on the fyi_users table. It does nothing but printing a simple static message.
USE FyiCenterData;
GO
CREATE TRIGGER dml_message ON fyi_users
AFTER INSERT, UPDATE, DELETE
AS
PRINT 'Records are inserted, updated,'
+ ' or deleted in fyi_users';
GO
Command(s) completed successfully.
A simple DML trigger is defined on fyi_users now.
⇒ Testing DML Triggers in SQL Server
⇐ Creating a Simple Table to Test Triggers in SQL Server
2016-10-25, 3138🔥, 0💬
Popular Posts:
How To Get the Definition of a Stored Procedure Back in SQL Server Transact-SQL? If you want get the...
What Are Date and Time Functions in MySQL? MySQL offers a number of functions for date and time valu...
Where to find answers to frequently asked questions on PHP Connections and Query Execution for MySQL...
What is test testing area for? The testing area is provided to allow visitors to post testing commen...
How To Convert Numeric Values to Integers in SQL Server Transact-SQL? Sometimes you need to round a ...