help with triggers

[jkmak]

I'd like to write a trigger. I'm told that they are wonderful, but have never written one. I'm trying to read a table, once the table is updated, gather SOME of that dat and update it in another table (both in the same database). Can someone guide me to some examples?

Thanks, Jeff

 

[tlbroadbent]

SQL Books Online has examples. Check this MSDN link.

http://msdn.microsoft.com/library/en-us/tsqlref/ts_create2_7eeq.asp

Terry L. Broadbent
FAQ183-874 contains tips for posting questions in these forums.
NOTE: Reference to the FAQ is not directed at any individual.

 

[foxdev]

While triggers can be "wonderful", they have a downside, and that is the performance impact they can have. Consider carefully whether you need a trigger to solve each issue you deal with, as they can significantly impact the performance of updates and inserts.

For example, say you need some fields from TableA to be copied to TableB when records are inserted. A trigger is normally what comes to mind. But imagine that TableB does not need to be up-to-the-minute; in fact, it can be stale for up to 24 hours without any business impact. In that situation, having a scheduled job to run once/twice/whenever per day would do the job, and more efficiently. Robert Bradley

http://www.agrainofhope.org

http://www.lowcostprints.com

http://www.foxdev.com