Chapter 12 -- Transactions and Triggers

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.



Inside Microsoft SQL Server 2000
Inside Microsoft SQL Server 2000
ISBN: 0735609985
EAN: 2147483647
Year: 2005
Pages: 179
Authors: Kalen Delaney

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net