How to prevent SQL update trigger from firing on insert?
Category: SQL Server 2005, T-SQLI have an insert trigger on TableA that updates Column1 in TableA. I also have an update trigger on TableA that I don't want to fire, or at least not to execute certain code, when a new record is inserted in the table. How can this be achieved? I don't want to use a...
View Answer
| Apr 22 2008 5:34 PM GMT
| asked by
Leo W
SQL Server, Triggers, T/SQL
Design a SQL Server trigger to calculate column averages and return them to another table
I'm quite new to SQL Server and I’m struggling to design a trigger. I need this trigger to execute daily and calculate averages of columns and return them to another table.
View Answer
| Mar 16 2008 10:25 PM GMT
| asked by
SQL Server Ask the Experts
SQL Server performance, SQL Server development, Triggers
Daily trigger in SQL
I'm trying to create a trigger to execute daily and calculate a few averages for me. Please help!
View Answer
| Mar 13 2008 6:50 AM GMT
| asked by
Barend IT
SQL, Triggers
DB Triggers and JPA
I have a physical file/table, on an iSeries, into which I drop a record containing UserID and Password. This action in turn fires a trigger that ends up calling the api QSYGETPH to verify the user's login credentials. This has been working for years under our previous architecture, wherein we...
View Answer
| Nov 8 2007 4:27 PM GMT
| asked by
Rdgrimes
iSeries, AS/400, JPA
Data Sync in tow tables
We are in the progress of restructing the old database. In this effort , we are joining data from 3 files files and creating a new schema. in the process of migration , we need to keep the new file and the old files in sync. How do we achive this? I was planning for triggers on Old file and the...
Answer Question
| Oct 19 2007 7:33 PM GMT
| asked by
Uiiuo
Schema, Oracle, Triggers
