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, 1376🔥, 0💬
Popular Posts:
How To Use "IF ... ELSE IF ..." Statement Structures in SQL Server Transact-SQL? "IF ... ELSE IF ......
How To Look at the Current SQL*Plus System Settings in Oracle? If you want to see the current values...
How to connect SQL Server Management Studio Express to SQL Server 2005 Express in SQL Server? Once y...
What Happens to Your Transactions When ERROR 1205 Occurred in MySQL? If your transaction receives th...
How To Use SQL*Plus Built-in Timers in Oracle? If you don't have a stopwatch/timer and want to measu...