SQL Server Trigger that works - fires just once

Posted by stckvrflw on Stack Overflow See other posts from Stack Overflow or by stckvrflw
Published on 2010-01-15T14:42:02Z Indexed on 2010/05/03 4:28 UTC
Read the original article Hit count: 264

Filed under:

I want to do some calculations when my table data is changed. However, I am updating my table manually and copy pasting about 3000 rows in once. That makes my trigger work 3000 times, but I want it to do the trigger only once.

Is there a way to do that ?

Thanks.

Related posts about trigger

consistency of Trigger Procedure (before row trigger) Postgresql

as seen on Stack Overflow - Search for 'Stack Overflow'
Using Postgresql. I try to use TRIGGER procedure to make some consistency check on INSERT. The question is ...... whether "BEFORE INSERT FOR EACH ROW" can make sure each row to insert "checked" and "inserted" one after another? do I need extra lock on table to survive from concurrent insert? check… >>> More
mutating, trigger/function may not see it- error during execution of trigger

as seen on Stack Overflow - Search for 'Stack Overflow'
CREATE OR REPLACE TRIGGER UPDATE_TEST_280510 AFTER insert on TEST_TRNCOMPVISIT declare V_TRNCOMPNO NUMBER(10); CURSOR C1 IS SELECT B.COMPNO FROM TEST_TRNCOMPVISIT A, TEST_TRNCOMPMST B, TEST_MEMMAST C WHERE A.COMPNO=B.COMPNO AND B.TRNMEMID=C.MEMID AND C.MEMOS=1000; begin open c1; fetch c1 into… >>> More
Behaviour of insertion trigger when defining autoincrement in Oracle

as seen on Stack Overflow - Search for 'Stack Overflow'
I have been looking for a way to define an autoincrement data type in Oracle and have found these questions on Stack Overflow: Autoincrement in Oracle Autoincrement Primary key in Oracle database The way to use autoincrement types consists in defining a sequence and a trigger to make insertion… >>> More
Returning Identity Value in SQL Server: @@IDENTITY Vs SCOPE_IDENTITY Vs IDENT_CURRENT

as seen on ASP.net Weblogs - Search for 'ASP.net Weblogs'
We have some common misconceptions on returning the last inserted identity value from tables. To return the last inserted identity value we have options to use @@IDENTITY or SCOPE_IDENTITY or IDENT_CURRENT function depending on the requirement but it will be a real mess if anybody uses anyone of these… >>> More
Returning Identity Value in SQL Server: @@IDENTITY Vs SCOPE_IDENTITY Vs IDENT_CURRENT

as seen on ASP.net Weblogs - Search for 'ASP.net Weblogs'
We have some common misconceptions on returning the last inserted identity value from tables. To return the last inserted identity value we have options to use @@IDENTITY or SCOPE_IDENTITY or IDENT_CURRENT function depending on the requirement but it will be a real mess if anybody uses anyone of these… >>> More

Developer IT

SQL Server Trigger that works - fires just once - Developer IT

SQL Server Trigger that works - fires just once

triggers

trigger

sql-server

query

tsql

Related posts about triggers

Instead of Triggers - Can they coexist with regular Triggers

Ask Tom - "The Trouble with Triggers"

"On Redefinition, Nature, and Triggers"

JDBC Triggers

Retrieving Stored procedures, Views, Functions, Triggers using Toad for Oracle

Related posts about trigger

consistency of Trigger Procedure (before row trigger) Postgresql

mutating, trigger/function may not see it- error during execution of trigger

Behaviour of insertion trigger when defining autoincrement in Oracle

Returning Identity Value in SQL Server: @@IDENTITY Vs SCOPE_IDENTITY Vs IDENT_CURRENT

Returning Identity Value in SQL Server: @@IDENTITY Vs SCOPE_IDENTITY Vs IDENT_CURRENT

Categories cloud