Trigger
What is the use of the trigger?

Answer Question   |  September 21, 2012  9:02 AM
SQL Trigger, Triggers

SQL trigger on column
Table have delete and update trigger. How to identify which columns are affected by this triigers? or  which column have  triggers ?

Answer Question   |  May 9, 2012  4:46 AM
SQL Server, SQL Trigger

Execute trigger only on update of selected fields
We have created some trigger programs in COBOL that should be executed only if certain fields change. When creating a SQL-After trigger and -program on a file I can specify that the trigger should run only when specified fields are updated by using: AFTER UPDATE OF {fields} ON {file}. Unfotunately when removing a SQL trigger [...]

Answer Question   |  January 4, 2011  11:00 AM
AS/400, AS/400 triggers, COBOL, SQL Trigger, Triggers

ORACLE-TRIGGERS
Hello, im going to create a trigger(insert or update) for a tableA, when it fires inserted or updated columns are should be insert or update into another table say tableB, one column(Processed_time) in tableB where its value will be by subtrcting two columns in tableA(response_time,Submission_time) all are timestamp type how to update(Processed_time) in tableB by [...]

Answer Question   |  July 1, 2010  11:46 AM
Oracle PL/SQL, Oracle SQL Developer, Oracle triggers, SQL Trigger

SQl Server 2008 Plain Text procedures results iin Encrypted Text within Profiler
I am attempting to trace some SQL activity on a SQL 2008, Standard SP1 64-bit server. In the profiler trace, I keep seeing Encrypted Text in the textdata column for triggers and procedures that are clearly plain text and are not encrypted. In this example, the object is a trigger. I do notice that the [...]

Answer Question   |  December 3, 2009  4:30 PM
SQL Encrypted Text, SQL Server 2008, SQL Server 2008 64-bit, SQL Trigger

Working TRIGGER and TRANSACTIONS QUESTION
Hello all, My company purchased an operations software (called [strong]darwin[/strong]) that works with SQL 2005 Server. I need to extract some data and save it in my Own Database, which is located in the same SQL Server. On the darwin software there is a screen that updates a field X in a table, which fires an an AFTER [...]

Answer Question   |  October 1, 2009  6:25 PM
SQL Server 2005, SQL Trigger, Transactions Per Second, TRIGGER

Why does my SQL Trigger malfunction?
I have the following code installed on my database. Create Trigger CFXSOUpdate On SalesOrder For Update AS If Update(SOM_DefaultRequiredDate) or Update(SOM_DefaultShipMethod) Declare @Body varchar (100) Set @Body= ‘The Required Date or Ship Method has been changed’ Exec master..xp_sendmail @recipients = ‘ARaedeke@Tri-Optic.com’, @subject = ‘Sales Order Change’, @message = ‘@Body’ The trigger fires when the fields [...]

Answer Question   |  February 17, 2009  6:43 PM
SQL Server, SQL Trigger