Testing DML Triggers in SQL Server

Q

How To Test a DML Trigger in SQL Server?

✍: FYIcenter.com

A

To test a DML trigger defined on a table, you just need to execute several INSERT, UPDATE and DELETE statements on that table as shown in this tutorial example:

USE FyiCenterData;
GO

INSERT INTO fyi_users (name) VALUES ('FYI Admin');
GO
Records are inserted, updated, or deleted in fyi_users
(1 row(s) affected)

UPDATE fyi_users SET email='root@fyicenter' 
  WHERE name = 'FYI Admin';
GO
Records are inserted, updated, or deleted in fyi_users
(1 row(s) affected)

DELETE FROM fyi_users WHERE name = 'FYI Admin';
GO
Records are inserted, updated, or deleted in fyi_users
(1 row(s) affected)

The trigger, dml_message, is working as expected.

 

Creating and Managing Triggers in SQL Server

⇒⇒SQL Server Database Tutorials

2016-10-25, 504👍, 0💬