Summary

In this chapter you learned how to use triggers to accomplish a variety of practical tasks. You learned how triggers are sometimes used to ensure referential integrity within a database, and how triggers can be set up on views as well as tables. You learned some techniques for writing efficient and low-maintenance trigger code, and you learned a bit about how triggers are processed internally by the server.

Get Guru's Guide to SQL Server™ Stored Procedures, XML, and HTML, The now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.