Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Syntax qustion when creating TEMP table on the fly
Message
From
17/04/2003 12:59:54
 
 
General information
Forum:
Microsoft SQL Server
Category:
Stored procedures, Triggers, UDFs
Miscellaneous
Thread ID:
00778391
Message ID:
00778935
Views:
14
Ironically, that's what I'd 'like' to do...I have a generic log stored proc that is maybe 20 lines of code at the most, and it's called from about 4 different update triggers [representing four production tables that users edit throughout the day]. So I personally don't see the harm in repeating 20 lines of code in 4 update triggers...having direct access to the INSERTED and DELETED tables will certainly cut down on a few lines of code in the trigger.

Unfortunately, our DBA doesn't realize that T-SQL is different from development languages in that trying to break things into multiple steps/procs [to reduce amount of code] winds up requiring more code and more complexity.

Our app is a financial app with some of the strictest auditing requirements I've ever seen.

Kevin
Previous
Reply
Map
View

Click here to load this message in the networking platform