How to create a trigger to update another table?
Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance
Hi All ,How can i create something like a trigger or procedure when i insert
a record in a table it updates a specific field of its parent record in the
parent table?
.
Relevant Pages
- Insufficient key column information for updating or refreshing
... I have a view which joins 4 tables, and im doing insert/updates on just one ... so i made a instead of trigger to accomplish ... this, this seems to work for the insert but not on the updates, in delphi it ... Prev by Date: ... (borland.public.delphi.database.ado) - Re: tracking Update, insert, delete during/after replication
... (transactional replication) ... Will a trigger perform ok on large sets of updates? ... Hugo Kornelis, SQL Server MVP ... (comp.databases.ms-sqlserver) - Re: SQL BEFORE puzzle
... hanging out here who is able to speak with authority on SQL. ... be prevented from doing any updates. ... "If the trigger is a BEFORE trigger and if, ... beforeT: update T .... ... (comp.databases.theory) - Re: SQL BEFORE puzzle
... hanging out here who is able to speak with authority on SQL. ... be prevented from doing any updates. ... "If the trigger is a BEFORE trigger and if, ... beforeT: update T .... ... (comp.databases.theory) - Re: Need advise about an application
... statistics generation can use the rest of the time, ... test/return) you should get back to other GUI events in time for screen ... updates, and without running into the start of the next timed check. ... signal from the device could have a function as a trigger. ... (comp.lang.python) |
|