Updating clause used in instead of trigger example
A trigger is a specification that the database should automatically execute a particular function whenever a certain type of operation is performed.
On tables, triggers can be defined to execute either before or after any triggers are fired once for each row that needs to be modified in the view.
create trigger [owner.]trigger_name on [owner.]table_name [as [if update (column_name) [ update (column_name)]...] SQL_statements [if update (column_name) [ update (column_name)]...
Properly written, this trigger function would be independent of the specific table it is triggering on.
Although these types of triggers can be used in a number of scenarios their primary function is to perform DML operations through such views.
It looks like a powerful capability and I am interested to know about the implementation of INSTEAD OF triggers for various DML operations.
I am making some tweaks to a legacy application built on SQL Server 2000, needless to say I only want to do the absolute minimum in the fear that it may just all fall apart.
I have a large table of users, tb Users, with a BIT flag for Is Deleted.