Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Trigger - Order of Execution
Message
 
 
À
31/01/2001 13:23:17
Roberto Cysne
Banco do Nordeste S.A.
Fortaleza, Brésil
Information générale
Forum:
Microsoft SQL Server
Catégorie:
Autre
Divers
Thread ID:
00470799
Message ID:
00471290
Vues:
18
>Hi,
>
> Please, anybody knows how to control the order of execution of
>many triggers on the same table ?
> Example:
> I have this insert triggers:
> TR_TAB_INS_1
> TR_TAB_INS_2
> TR_TAB_INS_3
> How determine the order of fired is 3, 2 and finally 1 ?
>
>Thanks,

as Mike said the order is undetermined in SQL Server 7. You could nest them if you want a specific order fired. Of course, you would have to have your server configured to allow nested triggers.
Larry Miller
MCSD
LWMiller3@verizon.net

Accumulate learning by study, understand what you learn by questioning. -- Mingjiao
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform