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.
2016-10-24, 663👍, 0💬
Popular Posts:
How To Replace Given Values with NULL using NULLIF() in SQL Server Transact-SQL? Sometime you want t...
How To Install PHP on Windows in MySQL? The best way to download and install PHP on Windows systems ...
How To Define an External Table in a Text File in Oracle? You can use the CREATE TABLE statement to ...
Where to find answers to frequently asked questions on INSERT, UPDATE and DELETE Statements in MySQL...
How AdventureWorksLT tables are related in SQL Server? There are 12 user tables defined in Adventure...