Recent IT Questions

1 - 5 of 5
<<PREVIOUS 1 NEXT>>

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


1 - 5 of 5
<<PREVIOUS 1 NEXT>>