Use of Triggers in Databse Systems
Not what you're looking for?
What are triggers used for, and why are they important in database systems? Provide an example of a situation where a trigger would be appropriate. What would the implementation of this trigger look like?
Purchase this Solution
Solution Summary
450+ words on the nature and implementation style of triggers
Solution Preview
A trigger is a special kind of stored procedure that executes automatically whenever an attempt is made to modify data in a table that the trigger protects. Triggers can include most Transact-SQL statements. When an attempt is made to insert, update, or delete data in a table and a trigger for that particular action has been defined on the table, the trigger executes automatically. A trigger cannot be circumvented.
Triggers are used to maintain low-level data integrity, not to return query results. The primary benefit of triggers is that they can contain complex processing logic. You should only use triggers when constraints do not provide the functionality you require.
The following are common reasons to use triggers:
cascade modifications through related ...
Purchase this Solution
Free BrainMass Quizzes
Word 2010: Table of Contents
Ever wondered where a Table of Contents in a Word document comes from? Maybe you need a refresher on the topic? This quiz will remind you of the keywords and options used when working with a T.O.C. in Word 2010.
Java loops
This quiz checks your knowledge of for and while loops in Java. For and while loops are essential building blocks for all Java programs. Having a solid understanding of these constructs is critical for success in programming Java.
Basic Computer Terms
We use many basic terms like bit, pixel in our usual conversations about computers. Are we aware of what these mean? This little quiz is an attempt towards discovering that.
Basic UNIX commands
Use this quiz to check your knowledge of a few common UNIX commands. The quiz covers some of the most essential UNIX commands and their basic usage. If you can pass this quiz then you are clearly on your way to becoming an effective UNIX command line user.
Word 2010: Tables
Have you never worked with Tables in Word 2010? Maybe it has been a while since you have used a Table in Word and you need to brush up on your skills. Several keywords and popular options are discussed as you go through this quiz.