Collections:
"DELETED" - Old Record of an DML Event Instance in SQL Server
How To Access the Deleted Record of an Event in SQL Server?
✍: FYIcenter.com
When a DML event occurs, SQL Server will prepare a temporary table called "DELETED", which contains the old record of the affected row, which is:
The tutorial exercise below shows you how to improve the trigger, update_user, to report email changes on table, fyi_users, with both old and new emails:
USE FyiCenterData; GO ALTER TRIGGER update_user ON fyi_users AFTER UPDATE AS DECLARE @new VARCHAR(80); DECLARE @old VARCHAR(80); SELECT @new = email FROM INSERTED; SELECT @old = email FROM DELETED; PRINT 'Email changed from '+@old+' to '+@new; GO UPDATE fyi_users SET email='king@fyicenter' WHERE name = 'John King'; GO Email changed from john@fyicenter to king@fyicenter (1 row(s) affected)
INSERTED and DELETED are working as expected. The reported message is getting better.
⇒ Improving the Trigger to Handle NULL Values in SQL Server
⇐ "INSERTED" - New Record of an DML Event Instance in SQL Server
2016-10-24, 1716🔥, 0💬
Popular Posts:
How to set database to be READ_ONLY in SQL Server? Databases in SQL Server have two update options: ...
How To End a Stored Procedure Properly in SQL Server Transact-SQL? Where the end of the "CREATE PROC...
What is test testing area for? The testing area is provided to allow visitors to post testing commen...
What Are the Underflow and Overflow Behaviors on FLOAT Literals in SQL Server Transact-SQL? If you e...
How To Verify a User name with SQLCMD Tool in SQL Server? The quickest way to verify a user name in ...