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, 1845🔥, 0💬
Popular Posts:
Why I Can Not Enter 0.001 Second in DATETIME values in SQL Server Transact-SQL? If you enter millise...
What Is Oracle in Oracle? Oracle is a company. Oracle is also a database server, which manages data ...
How To Start Instance with a Minimal Initialization Parameter File in Oracle? The sample initializat...
What Happens If the UPDATE Subquery Returns Multiple Rows in SQL Server? If a subquery is used in a ...
How To Round a Numeric Value To a Specific Precision in SQL Server Transact-SQL? Sometimes you need ...