Get more flexibility to validate modifications and update views
Last month, I talked about a new SQL Server 2000 feature called INSTEAD OF triggers. These triggers let you define a routine to execute in lieu of a particular data-manipulation operation. I showed you a routine to check whether a price change in the Titles table in the Pubs database met certain requirements. For this check, you could write an AFTER trigger (the default trigger type) that would compare the ...