SQLConfiguration 





SQL-Server Triggers  «Prev  Next»
Lesson 11

SQL-Server2012 Trigger Conclusion

This module discused how to use triggers to enforce the business rules that govern your database. Remember that triggers can lose their value, or even be harmful if they are not modified or deleted to accommodate business rule changes. You will find that many businesses change their business rules often to adapt to changing conditions. Be prepared to customize your database triggers as well, to keep up with these changes.
Having completed this module, you should be able to:
  1. Describe and define triggers
  2. Enforce business rules
  3. Create triggers
  4. Modify triggers
  5. Delete triggers
  6. Test triggers



Glossary terms

This module introduced you to the following terms:
  1. Business rule
  2. Cascade
  3. Event
  4. Fire
  5. Nesting
  6. Trigger
In the next module, you will learn about SQL Server 2000 stored procedures.

SQL Triggers - Quiz

Before moving on to the next module, click the Quiz link below to check your knowledge of the material covered in this module with a short, multiple-choice quiz.
SQL Triggers - Quiz