Update trigger - why it works? - Level Extreme

Plateforme Level Extreme

Abonnement

Profil corporatif

Produits & Services

Support

Légal

English

Update trigger - why it works?

Message

De

10/02/2008 15:24:43

Kevin Goff
Pennsylvanie, États-Unis

À

10/02/2008 15:19:53

Naomi Nosonovsky
Wisconsin, États-Unis

Information générale

Forum:

Microsoft SQL Server

Catégorie:

Syntaxe SQL

Titre:

Re: Update trigger - why it works?

Versions des environnements

SQL Server:

SQL Server 2005

Divers

Thread ID:

01291246

Message ID:

01291249

Vues:

11

This message has been marked as a message which has helped to the initial question of the thread.

I am not SURE of this, so you'll need to verify, but my guess is that if you define a trigger on table 'A'....and inside that trigger, you do an UPDATE on table 'A', the trigger won't refire.

Again, not sure, but that's my guess

"Run, you clever boy....and remember"
https://www.youtube.com/watch?v=8U4Y2Uv8ArM

"My survival...my living proof"
https://plus.google.com/photos/117162300364810952313/albums/5876836271056272097/5876836294121419858?banner=pwa&pid=5876836294121419858&oid=117162300364810952313

Click here to load this message in the networking platform