inserted and deleted tables should be supported in triggers
There is currently no support for the 'inserted' and 'deleted' tables within triggers. They should be treated as equivalent to the original table that the trigger is attached to.
37
votes
Benjamin S
shared this idea
This is included in SQL Prompt 6.3, which can be downloaded from http://www.red-gate.com/products/sql-development/sql-prompt/
-
Stephen
commented
Totally agree with John and Benjamin; this is a painful omission...
-
John Wood
commented
As useful as the rest of the SQL Prompt add-in is for developing statements and other "common" database functionalities. The ability to design Triggers at any level of the SQL Server and recognize these two distinct and isolated cache tables should be hands down included.