Collections:
Testing DML Triggers in SQL Server
How To Test a DML Trigger in SQL Server?
✍: FYIcenter.com
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.
⇒ sys.triggers - Listing All Triggers in the Database in SQL Server
⇐ "CREATE TRIGGER" - Creating a DML Trigger in SQL Server
2016-10-25, 1442🔥, 0💬
Popular Posts:
How to continue to the next iteration of a WHILE loop in SQL Server Transact-SQL? How to use CONTINU...
How To Change the Password for Your Own User Account in MySQL? If you want to change the password of...
What Is Oracle in Oracle? Oracle is a company. Oracle is also a database server, which manages data ...
How To Start MySQL Server in MySQL? If you want to start the MySQL server, you can run the "mysqld" ...
How To Update Multiple Rows with One UPDATE Statement in SQL Server? If the WHERE clause in an UPDAT...