Collections:
"ALTER TRIGGER" - Modifying Existing Triggers in SQL Server
How To Modify Existing Triggers using "ALTER TRIGGER" in SQL Server?
✍: FYIcenter.com
If you want to make changes to an existing trigger, you could use the "ALTER TRIGGER" statements to refine the trigger again. The tutorial exercise below shows you how to modify the trigger defined in a previous tutorial:
USE FyiCenterData; GO ALTER TRIGGER dml_message ON fyi_users AFTER INSERT, UPDATE, DELETE AS PRINT 'Time: '+CONVERT(VARCHAR(12),GETDATE()); PRINT 'Records are inserted, updated,' + ' or deleted in fyi_users'; GO UPDATE fyi_users SET email='john@fyicenter' WHERE id = 1; GO Time: Jul 1 2007 Records are inserted, updated, or deleted in fyi_users
An extra printing statement is added the trigger.
⇒ "DROP TRIGGER" - Deleting Existing Triggers in SQL Server
⇐ sys.triggers - Listing All Triggers in the Database in SQL Server
2016-10-24, 1250🔥, 0💬
Popular Posts:
How To Install PHP on Windows in MySQL? The best way to download and install PHP on Windows systems ...
How To Generate Random Numbers with the RAND() Function in SQL Server Transact-SQL? Random numbers a...
What Is a Parameter File in Oracle? A parameter file is a file that contains a list of initializatio...
How To Enter Unicode Character String Literals in SQL Server Transact-SQL? Unicode characters are mu...
What are binary literals supported in SQL Server Transact-SQL? Binary literals in Transact-SQL are s...