Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Refer to Column by position in a trigger
Message
From
12/07/2001 08:57:25
 
 
To
12/07/2001 03:55:21
General information
Forum:
Microsoft SQL Server
Category:
Stored procedures, Triggers, UDFs
Miscellaneous
Thread ID:
00528593
Message ID:
00529632
Views:
14
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
Previous
Reply
Map
View

Click here to load this message in the networking platform