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, 1305🔥, 0💬
Popular Posts:
What Is Oracle in Oracle? Oracle is a company. Oracle is also a database server, which manages data ...
How AdventureWorksLT tables are related in SQL Server? There are 12 user tables defined in Adventure...
How To Verify a User name with SQLCMD Tool in SQL Server? The quickest way to verify a user name in ...
What Is a Parameter File in Oracle? A parameter file is a file that contains a list of initializatio...
What is dba.FYIcenter.com Website about? dba.FYIcenter.com is a Website for DBAs (database administr...