Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Refer to Column by position in a trigger
Message
De
12/07/2001 08:57:25
 
 
À
12/07/2001 03:55:21
Information générale
Forum:
Microsoft SQL Server
Catégorie:
Stored procedures, Triggers, UDFs
Divers
Thread ID:
00528593
Message ID:
00529632
Vues:
15
IMO you're making this too hard. As you try to harder to make the trigger generic, you'll be adding in so many layers that you'll impact performance. Remember that the trigger is run for every transaction update to the table whether rows are actually updated or not.

Why not write a utility that creates the trigger for you based on information stored in the database catalog?

-Mike
Michael Levy
MCSD, MCDBA
ma_levy@hotmail.com
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform