SQL Server FAQ - "CREATE TRIGGER" - Creating a DML Trigger

Home >> FAQs/Tutorials >> SQL Server FAQ

By: FYIcenter.com

How To Create a DML Trigger using CREATE TRIGGER Statements?

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.

(Continued on next topic...)