Chapter 12
In this chapter, we'll continue looking at the use of Transact-SQL for creating programmable modules. In particular, we'll look at modules that automatically execute when some data modification statement is issued. This type of module is called a trigger. You can define a trigger to execute as an alternative to the requested data modification or to execute after the modification takes place. To thoroughly understand how triggers behave, you need to have a fuller understanding of transactions and transaction boundaries. This chapter will go into more detail about transactions and how they affect changes made by multiple users.